NET features found in .NET Framework 3.0, including extension methods and anonymous types.
In this chapter, you will explore LINQ to SQL queries, including the following:
??‘ LINQ to SQL query concepts
??‘ The DataContext class
??‘ Data manipulation via LINQ to SQL
??‘ Working with entity objects
??‘ Querying with stored procedures and user-defined functions
Query Concepts
By now you know that LINQ to SQL queries really are not any different from the other LINQ
queries you have seen and worked with throughout this book. They follow the same syntax format
as LINQ and LINQ to XML queries.
However, they vary in one area. In LINQ to XML you query an XML document tree or fragment
directly, but in LINQ to SQL you query mapped objects, meaning that the objects you are querying
are mapped to objects or items in a relational database, such as a table or stored procedure.
A LINQ to SQL query, like standard LINQ queries, has parts or actions of the query operation: the
obtaining of a data source, the query creation, and the query execution.
Pages:
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355