• Online, Self-Paced
Course 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.

Learning Objectives

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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.