Querying and Manipulating Data with the Entity Framework
Querying and Manipulating Data with the Entity Framework
-
Online, Self-Paced
Course Description
This course covers the Microsoft Entity Framework and its use as a data access technology in .NET applications, and is one of a series that prepares students for Microsoft exam 70-487.
Learning Objectives
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
Framework Connections
The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.
Feedback
If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.