O'Reilly logo

Programming Microsoft® ASP.NET 3.5 by Dino Esposito

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

Working with SQL Server

Linq-to-SQL brings LINQ query capabilities to SQL Server databases and translates your queries into T-SQL queries. The standard ADO.NET provider—System.Data.SqlClient—then takes care of executing the query. Results are returned via a data reader and, finally, loaded into an IQueryable collection of entity objects. The "entity objects" are the key element. They form a data model based on the database schema through which you operate on the data.

Note

One thing should be said up front and kept in mind: Linq-to-SQL is not a tool to build your middle tier. Don't be fooled by the fact it uses objects. It should be seen, instead, as a powerful tool to build a data access layer using objects and a high-level query syntax rather ...

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