• Online, Self-Paced
Course 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.

Learning Objectives

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

Querying Data with Entity

  • 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

Data Manipulation with Entity

  • 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

Practice: Data Modeling for Entity

  • manipulate data and data models using the Entity Framework

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Software Development