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