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