Chapter 20. Using LINQ to SQL

After completing this chapter, you will be able to:

  • Build LINQ queries that use the LINQ to SQL provider

  • Understand how LINQ to SQL prepares queries for processing

  • Determine when to use LINQ to SQL over LINQ to Entities

LINQ is an extensible system, enabling a consistent querying experience against different data platforms. Sometimes these different systems overlap, providing access to the same target platform through different providers. SQL Server is one such database platform. LINQ to DataSet and LINQ to Entities both allow you to build LINQ queries that interact with data sourced from SQL Server, either directly (LINQ to Entities) or indirectly (LINQ to DataSet). LINQ to SQL, also included as a native LINQ provider ...

Get Microsoft® ADO.NET 4 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.