immediate, 252??“255
immediate, 35??“36
local, 251, 252
remote, 251, 252
expressions, 21??“22, 55
C#, 22
Visual Basic, 22
LINQ, 31??“51
actions, 32??“36
common terms, 41??“43
concepts, 37??“43
data source, 32??“33
LINQ to SQL queries v., 218
parts, 32??“36
polymorphic, 42
query creation, 32, 33
syntax options, 43??“51
LINQ to DataSets, 275??“279
across multiple tables, 277??“278
single table, 275??“276
typed DataSets, 278??“279
LINQ to SQL, 207??“244
advanced concepts, 245??“256
compiled, 251
components involved, 218??“219
composite keys, 255
concepts, 217??“219
data manipulation via, 221??“225
database relationships, 245??“250
DataContext class, 219??“220
DataShape class, 254
deferred v. immediate data loading,
252??“255
deleting data, 225
entity objects, 225??“227
goal, 16
illustrations, 14??“15
inserting data, 222??“224
LINQ Provider, 41
LINQ queries v., 218
object model, 201??“202
overview, 14??“16, 200??“201
Person.Contact table and, 147??“149
read-only data, 255??“256
remote v. local execution, 251??“252
stored procedures, 227??“240
373
queries (continued)
queries (continued)
UDFs, 240??“243
updating data, 224??“225
LINQ to XML, 132??“137
syntax, 43, 45??“51, 275
example, 44
method syntax v.
Pages:
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568