Pro Entity Framework 4.0

1. Front Matter

   Pages i-xiii

   PDF

2. Introducing the ADO.NET 4.0 Entity Framework

   Pages 1-12

3. The Entity Data Model

   Pages 13-33

4. The Entity Data Model Inside and Out

   Pages 35-61

5. Querying the EDM

   Pages 63-81

6. Working with Entities

   Pages 83-92

7. Stored Procedures and the EDM

   Pages 93-108

8. Relationships and Associations

   Pages 109-126

9. T4 Code Generation

   Pages 127-143

10. Model-First Development

    Pages 145-166

11. Code-Only Development

    Pages 167-186

12. N-tier Development with WCF Data Services

    Pages 187-208

13. Performance Tuning and Exception Handling

    Pages 209-227

14. Data Binding with the Entity Framework

    Pages 229-251

15. Back Matter

    Pages 253-265

    PDF

Previously, SQL developers have been able to almost entirely ignore the SQLCLR and treat it as a peripheral technology—almost an extension to the main product. With the advent of LINQ and the Entity Framework, this is no longer the case, and the SQLCLR is moving to the center stage. It’s a powerful product but, for many, it is an entirely new way of working with data. Pro Entity Framework 4.0 will help readers understand the implications of the Entity Framework and how it can be used to change their development practices and make their databases more powerful and flexible. Since many readers will be encountering this subject for the first time, the book will create an inclusive environment in which the concepts of .NET development are approached from the perspective of the Relational T–SQL developer to foster a sense of shared–ownership in keeping with Microsoft’s latest best practices.

• Comprehensive coverage of the new greater and more challenging integration with .NET 3.5
• Written from a real–world perspective and examines the features offered by LINQ and the Entity Framework that will help solve problems experienced by professional developers
• Contains insight, interpretation, analysis, and evangelism instead of just plain fact

• .NET
• ADO
• Microsoft SQL Server
• SQL
• SQL Server 2005
• SQL Server 2008
• data model

Scott Klein is a Microsoft SQL Server "Most Valuable Professional" and independent consultant specializing in SQL Server performance and business intelligence. Scott is the author of several books, including Professional SQL Server 2005 XML, Professional LINQ, and Pro ADO.NET 4.0 Entity Framework. He was a contributing author to Pro SQL Server 2008 Relational Database Design and Implementation, as well as to the Microsoft SQL Server 2008 Bible. Scott has written many articles for the SQL Server Standard magazine. He holds the MCDBA, MCSD, and MCSE certifications. He is heavily involved in the south Florida community, running two SQL Server user groups and the South Florida SQL Saturday events. Scott also speaks frequently at user groups across south Florida. Scott has nearly 20 years working with SQL Server and consulting in small to enterprise-size environments.

Policies and ethics