O'Reilly logo

SQL Server MVP Deep Dives by Greg Low, Paul Randal, Kimberly Tripp, Adam Machanic, Kalen Delaney, Paul Nielsen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 15. LINQ to SQL and ADO.NET Entity Framework

Bob Beauchemin

In ADO.NET 3.5 and 3.5 SP1, Microsoft introduced two models designed to abstract SQL statements into a high-level language and to operate on database data as objects. The first, LINQ to SQL, is a lightweight mapping of LINQ (Language Integrated Query) calls to the SQL Server database. The other model, ADO.NET Entity Framework (EF), consists of an object-relational mapping (ORM) framework as well as query and view services built over the ADO.NET provider model. The Entity Framework has its own dialect of SQL (Entity SQL or ESQL) and can use ESQL statements or LINQ queries to access data. Although neither framework uses vanilla T-SQL as its query language, both frameworks can ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required