Querying and Manipulating Data with the Entity Framework

Overview/Description
This course covers the Microsoft Entity Framework and its use as a data access technology in .NET applications, and is one of a series that prepares students for Microsoft exam 70-487.

Target Audience
Developers wanting to understand the Microsoft Entity Framework and those preparing for Microsoft exam 70-487.

Prerequisites
None

Expected Duration (hours)
2.5

Lesson Objectives

Querying and Manipulating Data with the Entity Framework

• start the course
• explain the key elements of Entity Framework queries
• use Entity SQL to query data
• update, insert, and delete data using the DbContext API for Entity Framework
• use the query and command building blocks of Entity Framework
• manipulate data directly using Entity Framework
• query and manipulate data using both synchronous and asynchronous approaches with Entity Framework
• use Entity Framework to modify data provider settings
• use LINQ operators with Entity Framework via LINQ to Entities
• use LINQ to Entities to log queries and troubleshoot a system
• distinguish between the IQueryable and IEnumerable interfaces
• use stored procedures with Entity Framework to read and update the database
• perform asynchronous LINQ to Entities queries
• use a SQL Azure database with Entity Framework
• define deferred execution
• distinguish between eager and lazy loading in Entity Framework
• implement transaction requirements within the Entity Framework data layer
• identify the modeling languages used in Entity Framework and how they fit together
• modify Entity Framework conceptual model artifacts
• modify Entity Framework data model artifacts
• implement custom conventions when using a Code First approach in Entity Framework
• use the table per type approach when creating an Entity Framework data model
• use the table per class approach when creating an Entity Framework data model
• use the table per hierarchy approach when creating an Entity Framework data model
• implement Entity Framework components using a Code First approach
• implement Entity Framework components using a Model First approach
• implement Entity Framework components using a Database First approach
• overlay Entity Framework on existing CLR objects
• implement data access using the Entity Framework