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