Querying and Manipulating Data with the Entity Framework


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


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.9

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

    • Course Number:
    cl_mazw_a02_it_enus

    Expertise Level
    Expert