• Online, Self-Paced
Course Description

This course introduces Entity Framework and its modeling concepts and approaches, and demonstrates how to use it to read data from and write data to a database.

Learning Objectives

An Introduction To Entity Framework

  • start the course
  • define the Entity Framework
  • install and update Entity Framework
  • define the three components that constitute an Entity Framework model
  • compare the DbContext and Object contexts
  • use entity tracking and caching
  • describe Entity Framework's approach to concurrency

Working with LINQ To Entities

  • read data from a database using LINQ To Entities
  • add new records to a database using LINQ To Entities
  • use database functions in LINQ To Entities queries and statements
  • use stored procedures with LINQ To Entities to read and update a database
  • implement distributed or explicit transactions with LINQ To Entity commands
  • distinguish between the IQueryable and IEnumerable interfaces
  • describe how entities are validated at Insert and Update time

Working with Entity SQL

  • work with Entity Framework's database interaction components
  • read data from a database using Entity SQL
  • update a database using Entity SQL
  • implement distributed or explicit transactions with Entity SQL commands

Building Entity Data Models

  • implement Entity Framework components using a Database-First approach
  • implement Entity Framework components using a Model-First approach
  • implement Entity Framework components using a Code-First approach
  • override mappings for Code-First Entity Framework models
  • use the Code-First approach for an existing database
  • implement custom conventions when using a Code-First approach
  • implement custom pluralization and singularization of entity and collection names in Entity Framework
  • work with out-of-band Entity Framework Power Tools from Microsoft
  • perform database migrations in Entity Framework

Implementing Hierarchies with Entity Framework

  • use the Table-per-Type approach to create an Entity Framework data model
  • use the Table-per-Class approach to create an Entity Framework data model
  • use the Table-per-Hierarchy approach to create an Entity Framework data model

Practice: Code-First Modeling and Queries

  • use the code-first modeling approach and execute queries with Entity Framework

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Software Development