Querying and Manipulating Data with the Entity Framework

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

Prerequisite
None

Expected Duration
173 minutes

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.

Objective

Introducing Entity Framework

  • start the course
  • explain the key elements of Entity Framework queries
  • use Entity SQL to query data
  • Querying and Manipulating 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
  • Querying Data Using LINQ to Entities

  • 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
  • Entity Framework Modeling

  • 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
  • Exploring Hierarchies with 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
  • Understanding Entity Framework’s Entry Points

  • 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
  • Practice: Working with Entity Framework

  • implement data access using the Entity Framework
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.