Mosh Hamedani – Entity Framework 6 in Depth

Check it out: Mosh Hamedani – Entity Framework 6 in Depth

Entity Framework is an Object / Relational Mapper (O/RM) that helps you read and write data from and to a database. In this course, Mosh, teaches you the core concepts of Entity Framework through a series of clear, concise and hands-on lectures.

Whether you’re new to Entity Framework, or been using it for a while but are looking for a comprehensive course with a clean structure to fill the missing parts, you’re going to love this course.

By the end of watching this course, you’ll be able to:

Understand the differences between code-first and database-first workflows
Build a domain model using database-first workflow
Build a domain model using code-first workflow (with a new or an existing database)
Use code-first migrations to upgrade or downgrade your 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 your applications
Understand what the repository pattern is, why and when to use it and how
Apply best practices with Entity Framework

Unlike other books or courses that teach Entity Framework like a manual, I walk you through real-world scenarios using my extensive experience in the field. Not only will you learn the fundamentals of Entity Framework, but you’ll also learn the best practices along the way.

In each section, you’ll find exercises to help you reinforce the materials. These exercises have been chosen from real-world scenarios to help you prepare for the challenges of the real-world. Also, some sections include cheat sheets so you can quickly review what you learn in that section.

This course is produced with Entity Framework 6. If you’re using an older version of Entity Framework, you can still take this course as long as your version of Entity Framework is 4.1 or higher.

Course Curriculum

Introduction (1m)
About this Course (1:00)
Getting ed (35m)
Introduction (0:25)
PreviewWhat is Entity Framework (1:07)
PreviewWorkflows (1:33)
PreviewDemo- Database-first Workflow (10:22)
PreviewDemo- Code-first Workflow (9:07)
PreviewDatabase-first or Code-first (3:41)
Summary (0:24)
Building a Model Using Data-base First Workflow (40m)
Introduction (0:35)
Setting Up the Database (0:54)
A Quick Tour of EDMX Designer (6:46)
Uncovering the EDMX (6:56)
Connection Strings (3:16)
Dealing with Database Changes (13:30)
Importing Stored Procedures (5:28)
Function Imports (7:38)
Working with Enums (7:22)
Db First – Exercises
Summary (0:17)
Building a Model Using Code-first Workflow (40m)
Introduction (0:23)
Code First with a New Database (13:15)
Code First with Existing Database (6:58)
Enabling Migrations (4:21)
Adding a New Class (9:29)
Modifying an Existing Class (8:25)
Deleting an Existing Class (5:53)
Recovering from Mistakes (1:22)
Downgrading a Database (6:01)
Seeding Database (6:27)
Exercise
Summary (0:26)
Overriding Code-First Conventions (1h10m)
Introduction (0:25)
Overriding Conventions (8:16)
Data Annotations (7:17)
Demo- Data Annotations (8:04)
Fluent API- Basics (3:45)
Fluent API- Relationships (10:05)
Demo- Fluent API (13:28)
Fluent API- Demo Advanced (4:03)
Organizing Fluent API Configurations (7:37)
Exercise
Summary (0:35)
Querying Data (35m)
Introduction (0:18)
What is LINQ (3:19)
LINQ in Action (7:49)
LINQ Syntax (17:00)
LINQ Extension Methods (16:09)
LINQ Extension Methods- Additional Methods (5:41)
Deferred Execution (7:11)
IQueryable (7:40)
Exercise
Summary (0:37)
Loading Related Objects (20m)
Introduction (0:14)
Lazy Loading (8:05)
N+1 Problem (2:59)
Eager Loading (6:00)
Explicit Loading (8:55)
Exercise
Summary (0:43)
Changing Data (30m)
Introduction (0:29)
Overview of Changing Data (1:23)
Adding Objects (7:49)
Updating Objects (2:22)
Removing Objects (6:44)
Working with Change Tracker (6:03)
LINQPad (7:27)
Exercise
Summary (0:20)
Using Entity Framework in Your Applications (35m)
Introduction (0:33)
Repository Pattern (11:42)
Implementing Repository (14:35)
Structuring Your Application (4:09)
ASP.NET MVC Example (7:42)
Wpf Example (6:14)
Summary (1:01)