entity framework

By attending Entity Framework workshop, Participants will learn to:

  • Understand the differences between database-first and code-first workflows
  • Build a domain model using database-first workflow
  • Build a domain model using code-first workflow (with an existing or a new database)
  • Use code-first migrations to upgrade or downgrade participants database
  • Override code-first conventions (using data annotations and fluent API)
  • Query data using LINQ (using query syntax and extension methods)
  • Use eager loading, lazy loading and explicit loading effectively
  • Add, update and remove objects
  • Use additional tools to profile and troubleshoot participants applications
  • Understand what the repository pattern is, what and if participants need it, and how to implement it
  • Apply best practices with Entity Framework

  • Any .NET developer who wants to persist or query domain objects from a database

COURSE AGENDA

  • Setting up the Database
  • A Quick Tour of EDMX Designer
  • Uncovering the EDMX
  • Connection Strings
  • Dealing with Database Changes
  • Importing Stored Procedures
  • Function Imports
  • Working with Enums
  • Introduction
  • What is Entity Framework?
  • Workflows
  • Database-First or Code-First?
  • Code First with a New Database
  • Code First with an Existing Database
  • Migrations: Enabling Migrations
  • Migrations: Adding a New Class
  • Migrations: Modifying an Existing Class
  • Migrations: Deleting an Existing Class
  • Migrations: Recovering from Mistakes
  • Migrations: Downgrading a Database
  • Seeding Database
  • Overriding Conventions
  • Data Annotations
  • Demo: Data Annotations
  • Fluent API: Basics
  • Fluent API: Relationships
  • Organizing Fluent API Configurations
  • Introduction to LINQ
  • LINQ in Action
  • LINQ Syntax
  • LINQ Extension Methods
  • LINQ Extension Methods: Additional Methods
  • Deferred Execution
  • IQueryable Explained
  • Lazy Loading
  • N + 1 Problem
  • Eager Loading
  • Explicit Loading
  • Overview of Changing Data
  • Adding objects
  • Updating objects
  • Removing objects
  • Working with Change Tracker
  • LINQPad
  • Repository Pattern
  • Implementing the Repository Pattern
  • Structuring Participants Applications
  • ASP.NET MVC Example