Annotation 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.0will 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.5Written from a real–world perspective and examines the features offered by LINQ and the Entity Framework that will help solve problems experienced by professional developersContains insight, interpretation, analysis, and evangelism instead of just plain factWhat you’ll learnExamine the SQLCLR architecture.Learn the fundamentals of LINQ.Use LINQ with SQL and datasets.Extend LINQ.Gain a holistic view of the features of LINQ and the Entity Framework and how they segue with other features of the .NET Framework and native features of the operating system.Write practical applications of LINQ and the Entity Framework.Who this book is for.NET and SQL developers who use Microsoft SQL Server 2008 as their back–end database. Database administrators who create, manage, and secure those databases.Table of ContentsIntroducing the ADO.NET 4.0 Entity FrameworkThe Entity Data ModelThe Entity Data Model Inside and OutQuerying the EDMWorking with EntitiesStored Procedures and the EDMRelationships and AssociationsT4 Code Generation Model-First DevelopmentCode-Only DevelopmentN-tier Development with WCF Data ServicesPerformance Tuning and Exception HandlingData Binding with the Entity Framework