Developing Azure and Web Services: Entity Framework Overview/Description 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. Explore Entity and the operations it provides to make working with data easier.
Expected Duration (hours)
2.0
Lesson 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
Course Number: it_wddmaw_02_enus
Expertise Level
Expert