LINQ in Action

Chapter 8. Advanced LINQ to SQL features

This chapter covers:

• Handling concurrency
• Working directly with the database using pass-through queries, stored procedures, and user defined functions
• Improving the business tier with compiled queries, partial classes, partial methods, and object inheritance
• Comparison of LINQ to SQL with LINQ to Entities

In the last couple of chapters, we discussed the core components of working with relational data using LINQ to SQL. We saw how the mapping metadata combined with the IQueryable interface and expression trees to enable us to apply the same LINQ to Objects query expressions to relational data stores. By leveraging common APIs, we can eliminate vast amounts of data plumbing code and focus more directly ...