• Online, Self-Paced
Course Description

Entity Framework is an object relational mapper (ORM) and uses an object-oriented representation for data. Explore Entity and the operations it provides to make working with data easier.

Learning Objectives

Developing Azure and Web Services: Entity Framework

  • 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
  • build a query that uses deferred execution
  • implement lazy loading and eager loading
  • creating and running compiled queries
  • 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
  • implement Entity Framework using MySQL
  • implement Entity Framework using SQLite
  • designing strategy to target multiple databases
  • handling ON DUPLICATE KEY
  • manipulate data and data models 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.