SkillSoft Explore Course – Lambers, Inc.

IT Professional Curricula Software Development Solution Area Microsoft ORM Microsoft Entity Framework

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.

Asset ID	sd_etyf_a01_it_enus
Course Type	Video Course
Course Category	Software Development Solution Area

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

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