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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.