Introduction to the Entity Framework Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description
Entity Framework is an object relational mapper (ORM) and uses an object-oriented representation for data. This course introduces Entity and the operations it provides to make working with data easier, and prepares you for exam 70-487.
Target Audience
Software developers and database administrators who need to understand the relationship between Entity and the database model
Prerequisites
None
Expected Duration (hours)
1.2
Lesson Objectives Introduction to the Entity Framework
start the course
describe the need for object relational mappers and the development approaches including database first, model first, and code first
create and configure a DBContext and query the database using the DBContext class
use Data Annotations to manually map classes to database schema objects
describe the Entity methods for mapping an OOP environment to database tables
use the Fluent API to map classes to tables
work with data model schema definition languages to model data
define LINQ and how it interacts with SQL and Entity
use LINQ to Entities to query a database
perform a query against a database using Entity SQL
execute SQL statements directly using Entity and return objects or scalar values
perform Create, Read, Update, and Delete operations using Entity
use Change Tracking with Entity to monitor if an object has changed
use Transactions and the TransactionScope class to group operations
log and track queries and commands sent to a database
manipulate data and data models using the Entity Framework
Course Number: wd_dmaw_a02_it_enus
Expertise Level
Expert