Querying and Manipulating Data with the Entity Framework

Introducing Entity Framework

• start the course
• explain the key elements of Entity Framework queries
• use Entity SQL to query data

Querying and Manipulating Data

• update, insert, and delete data using the DbContext API for Entity Framework
• use the query and command building blocks of Entity Framework
• manipulate data directly using Entity Framework
• query and manipulate data using both synchronous and asynchronous approaches with Entity Framework
• use Entity Framework to modify data provider settings

Querying Data Using LINQ to Entities

• use LINQ operators with Entity Framework via LINQ to Entities
• use LINQ to Entities to log queries and troubleshoot a system
• distinguish between the IQueryable and IEnumerable interfaces
• use stored procedures with Entity Framework to read and update the database
• perform asynchronous LINQ to Entities queries
• use a SQL Azure database with Entity Framework
• define deferred execution
• distinguish between eager and lazy loading in Entity Framework
• implement transaction requirements within the Entity Framework data layer

Entity Framework Modeling

• identify the modeling languages used in Entity Framework and how they fit together
• modify Entity Framework conceptual model artifacts
• modify Entity Framework data model artifacts
• implement custom conventions when using a Code First approach in Entity Framework

Exploring Hierarchies with Entity Framework

• use the table per type approach when creating an Entity Framework data model
• use the table per class approach when creating an Entity Framework data model
• use the table per hierarchy approach when creating an Entity Framework data model

Understanding Entity Framework's Entry Points

• implement Entity Framework components using a Code First approach
• implement Entity Framework components using a Model First approach
• implement Entity Framework components using a Database First approach
• overlay Entity Framework on existing CLR objects

Practice: Working with Entity Framework

• implement data access using the Entity Framework