Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Entity Framework

( Duration: 3 Days )

By attending Entity Framework workshop, delegates 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 delegates 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 delegates applications
  • Understand what the repository pattern is, what and if delegates need it, and how to implement it
  • Apply best practices with Entity Framework

  • This Entity Framework training course is intended for any .NET developer who wants to persist or query domain objects from a database

COURSE AGENDA

1

Getting Started

  • Introduction
  • What is Entity Framework?
  • Workflows
  • Database-First or Code-First?
2

Building a Model using Database-First Workflow

  • 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
3

Building a Model using Code-First Workflow

  • 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
4

Overriding Code-First Conventions

  • Overriding Conventions
  • Data Annotations
  • Demo: Data Annotations
  • Fluent API: Basics
  • Fluent API: Relationships
  • Organizing Fluent API Configurations
5

Querying Data using LINQ

  • Introduction to LINQ
  • LINQ in Action
  • LINQ Syntax
  • LINQ Extension Methods
  • LINQ Extension Methods: Additional Methods
  • Deferred Execution
  • IQueryable Explained
6

Loading Related Objects

  • Lazy Loading
  • N + 1 Problem
  • Eager Loading
  • Explicit Loading
7

Updating Data

  • Overview of Changing Data
  • Adding objects
  • Updating objects
  • Removing objects
  • Working with Change Tracker
  • LINQPad
8

Using Entity Framework in an Application

  • Repository Pattern
  • Implementing the Repository Pattern
  • Structuring delegates Applications
  • ASP.NET MVC Example
9

Conclusion

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X