Mosh Hamedani – Entity Framework 6 in Depth

Proof of item:

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)
StartAbout this Course (1:00)
Getting Started (35m)
StartIntroduction (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)
StartSummary (0:24)
Building a Model Using Data-base First Workflow (40m)
StartIntroduction (0:35)
StartSetting Up the Database (0:54)
StartA Quick Tour of EDMX Designer (6:46)
StartUncovering the EDMX (6:56)
StartConnection Strings (3:16)
StartDealing with Database Changes (13:30)
StartImporting Stored Procedures (5:28)
StartFunction Imports (7:38)
StartWorking with Enums (7:22)
StartDb First – Exercises
StartSummary (0:17)
Building a Model Using Code-first Workflow (40m)
StartIntroduction (0:23)
StartCode First with a New Database (13:15)
StartCode First with Existing Database (6:58)
StartEnabling Migrations (4:21)
StartAdding a New Class (9:29)
StartModifying an Existing Class (8:25)
StartDeleting an Existing Class (5:53)
StartRecovering from Mistakes (1:22)
StartDowngrading a Database (6:01)
StartSeeding Database (6:27)
StartExercise
StartSummary (0:26)
Overriding Code-First Conventions (1h10m)
StartIntroduction (0:25)
StartOverriding Conventions (8:16)
StartData Annotations (7:17)
StartDemo- Data Annotations (8:04)
StartFluent API- Basics (3:45)
StartFluent API- Relationships (10:05)
StartDemo- Fluent API (13:28)
StartFluent API- Demo Advanced (4:03)
StartOrganizing Fluent API Configurations (7:37)
StartExercise
StartSummary (0:35)
Querying Data (35m)
StartIntroduction (0:18)
StartWhat is LINQ (3:19)
StartLINQ in Action (7:49)
StartLINQ Syntax (17:00)
StartLINQ Extension Methods (16:09)
StartLINQ Extension Methods- Additional Methods (5:41)
StartDeferred Execution (7:11)
StartIQueryable (7:40)
StartExercise
StartSummary (0:37)
Loading Related Objects (20m)
StartIntroduction (0:14)
StartLazy Loading (8:05)
StartN+1 Problem (2:59)
StartEager Loading (6:00)
StartExplicit Loading (8:55)
StartExercise
StartSummary (0:43)
Changing Data (30m)
StartIntroduction (0:29)
StartOverview of Changing Data (1:23)
StartAdding Objects (7:49)
StartUpdating Objects (2:22)
StartRemoving Objects (6:44)
StartWorking with Change Tracker (6:03)
StartLINQPad (7:27)
StartExercise
StartSummary (0:20)
Using Entity Framework in Your Applications (35m)
StartIntroduction (0:33)
StartRepository Pattern (11:42)
StartImplementing Repository (14:35)
StartStructuring Your Application (4:09)
StartASP.NET MVC Example (7:42)
StartWpf Example (6:14)
StartSummary (1:01)