Entity Framework for the DB Administrator
ADO.NET Entity Framework 4 (EF4) is Microsoft’s recommended data access layer for new applications. EF4 can be used to perform CRUD operations with very expressive query capabilities. After a brief overview of EF4 use from a developer perspective we will discuss how the Entity Framework can be a compliment to the general concerns that Database Administrators express. In particular this talk will investigate how the Entity Framework enables developers and DBAs to agree on a conceptual model that acts as a shared contract, providing DBAs control over their database and the entry points into the system that developers utilize by using the Entity Framework’s mapping technology and related features. We will then look at EF query performance including dynamic SQL generation, stored procedure use, and views and will outline recommendations for how to use each with EF.
Senior Program Manager
Register Now for PASS Summit 2010!