Getting Started With Entity Framework

Developers wanting to learn about the Entity Framework

Prerequisite
None

Expected Duration
202 minutes

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.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.