Working with the ADO.NET Entity Framework 4 Using C# 2010

Course details

The ADO.NET Entity Framework provides developers with the tools and framework elements they need to create unique, flexible data applications, while minimizing the amount of code required. This course explores the various ways you can employ the ADO.NET Entity Framework to develop and optimize data applications. Specific topics covered include Entity Data Models, ADO.NET Object Services, POCO support, the EntityClient Provider and Connection Strings, and WCF Data Services. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist: Accessing Data with Microsoft .NET Framework 4 Exam 70-516. Passing this exam will earn the learner credit towards the MCTS: .NET Framework 4, Data Access certification.

• recognize the key features of the ADO.NET Entity Framework
• create an Entity Data Model
• create a database using an Entity Framework model
• update the Entity Data Model using the Update Model Wizard
• edit the .edmx file manually by adding a defining query
• map entity model operations to stored procedures
• create complex types
• add a function to the .edmx file
• complete the code to build an object query against the Entity Data Model
• identify the code used to shape query results
• identify how code is used to ensure changed data is written back to the data store and transactions are managed
• identify the code used to customize data classes for use with an Entity Data Model
• incorporate POCOs in a data model
• work with POCOs
• recognize key code elements associated with the EntityClient Provider
• recognize key Connection String parameters
• generate an Entity Data Model (EDM)
• complete an object query
• perform coding task to ensure changed data is written back to the data store
• use key classes and commands associated with the EntityProvider class
• create data services
• enable access to data services
• query data services