Getting Started With Entity Framework

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

Expertise Level
Beginner