Course Details

Previous Page


Getting Started With Entity Framework


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



Overview/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.

Target Audience
Developers wanting to learn about the Entity Framework

Prerequisites
None

Expected Duration (hours)
3.4

Lesson Objectives

Getting Started With 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
  • 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
  • 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
  • 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
  • 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
  • use the code-first modeling approach and execute queries with Entity Framework
  • Course Number:
    sd_etyf_a01_it_enus