Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Emotional Intelligence CBT
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Development Tools Entity Framework

Entity Framework in Depth: The Complete Guide

Connect your applications to a SQL Server database
Bestseller
Rating: 4.6 out of 54.6 (8,894 ratings)
41,452 students
Created by Mosh Hamedani
Last updated 8/2018
English
English, French [Auto], 
30-Day Money-Back Guarantee

What you'll learn

  • 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 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, what and if you need it, and how to implement it
  • Apply best practices with Entity Framework
Curated for the Udemy for Business collection

Course content

10 sections • 79 lectures • 6h 34m total length

  • Preview01:00
  • Preview01:35
  • Asking Questions
    00:33

  • Preview00:26
  • What is Entity Framework?
    Preview01:07
  • Preview01:33
  • Preview10:22
  • Demo: Code-First Workflow
    09:07
  • Database-First or Code-First?
    03:41
  • Summary
    00:24

  • Introduction
    00:35
  • Setting up the Database
    00:54
  • A Quick Tour of EDMX Designer
    06:46
  • Uncovering the EDMX
    06:56
  • Connection Strings
    03:16
  • Dealing with Database Changes
    13:30
  • Importing Stored Procedures
    05:28
  • Function Imports
    07:38
  • Working with Enums
    07:22
  • Exercises
    3 pages
  • Summary
    00:17

  • Introduction
    00:23
  • Code First with a New Database
    13:15
  • Code First with an Existing Database
    06:58
  • Migrations: Enabling Migrations
    04:21
  • Migrations: Adding a New Class
    09:29
  • Migrations: Modifying an Existing Class
    08:25
  • Migrations: Deleting an Existing Class
    05:53
  • Migrations: Recovering from Mistakes
    01:22
  • Migrations: Downgrading a Database
    06:01
  • Seeding Database
    06:27
  • Exercises
    2 pages
  • Summary
    00:27

  • Introduction
    00:25
  • Overriding Conventions
    08:17
  • Data Annotations
    07:17
  • Demo: Data Annotations
    08:04
  • Fluent API: Basics
    03:45
  • Fluent API: Relationships
    10:05
  • Demo: Fluent API
    13:28
  • Demo: Fluent API (Advanced Configurations)
    04:03
  • Organizing Fluent API Configurations
    07:37
  • Exercises
    3 pages
  • Summary
    00:36

  • Introduction
    00:18
  • Introduction to LINQ
    03:19
  • LINQ in Action
    07:49
  • LINQ Syntax
    17:00
  • LINQ Extension Methods
    16:09
  • LINQ Extension Methods: Additional Methods
    05:41
  • Deferred Execution
    07:11
  • IQueryable Explained
    07:40
  • Exercises
    3 pages
  • Summary
    00:37

  • Introduction
    00:14
  • Lazy Loading
    08:05
  • N + 1 Problem
    02:59
  • Eager Loading
    06:00
  • Explicit Loading
    08:55
  • Exercises
    1 page
  • Summary
    00:43

  • Introduction
    00:29
  • Overview of Changing Data
    01:23
  • Adding objects
    07:49
  • Updating objects
    02:22
  • Removing objects
    06:44
  • Working with Change Tracker
    06:03
  • LINQPad
    07:27
  • Exercises
    1 page
  • Summary
    00:20

  • Introduction
    00:33
  • Repository Pattern
    11:42
  • Implementing the Repository Pattern
    14:35
  • Structuring Your Applications
    04:09
  • ASP.NET MVC Example
    07:42
  • WPF Example
    06:14
  • Summary
    01:01

  • Final Words
    01:01
  • Preview00:20

Requirements

  • Good understanding of advanced C# constructs (generics, lambda expressions)

Description

With over 6,500 students and 1,500+ positive reviews, this course is Udemy's most popular course for learning Entity Framework! 


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, Mosh walks you through real-world scenarios using his extensive experience in the field. Not only does he teach you the fundamentals of Entity Framework, he'll also teach you 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.



PREREQUISITES

In order to take this course, you should have at least 3 months experience programming in C#. If you need to strengthen your C# fundamentals, you can take Mosh's related courses:

  • C# Basics for Beginners
  • C# Intermediate: Classes, Interfaces and Object-oriented Programming
  • C# Advanced 



WHAT OTHER STUDENTS WHO HAVE TAKEN THIS COURSE SAY:

"May God bless you and your efforts to create high quality courses. This has really changed my life from working as a security guard and doing websites for free, now I am a professional." -Danish Jafri


"I'm impressed by Mosh's ability to strike the right balance of topic background, demo and tip and tricks to get around common issues when learning a technology. Great job Mosh! I'm more than happy to have invested my time and money in your work." -Ben Holtzman


"Excellent course! Mosh has a brilliant style and all of his courses are well presented and very high quality. This course was no exception and I learnt a lot from it." -Steven Barnett


"It´s a pleasure following the lessons, It´s like a good book, you always want to read another chapter. This is not siimple a course of EF, it goes further, gives a very good explanation of Linq and the most brilliant description of Repository Pattern and Unity of work. Please keep doing courses. To be honest I believe that you should leave your work and spend the rest of your life teaching ;)." -Martin Suarez


"I'd taken a lot of video classes, and this is the best I'd taken. Very well explained, detailed and a good real life examples, lots of tips and more." -Oscar Vargas


"As always... Mosh nails it with his thorough explanations (without all the "I'm better than you vibe")." -Mike Loffland



100% MONEY-BACK GAUARANTEE

This course comes with a 30-day money back guarantee. If you're not happy, ask for a refund, all your money back, no questions asked.



Do you want to take your programming skills to the next level?

Join the other 6,500 happy students who have taken this course and start coding within minutes.

Who this course is for:

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

Featured review

Robert Marriott
Robert Marriott
127 courses
44 reviews
Rating: 5.0 out of 5a year ago
This course is worth every penny, even if I'd paid full price. In the series, Mosh answered all my questions about Entity Framework, Linq and the best patterns to apply them. Even though this course was created a few years ago, it's still completely relevant today with .Net Core. Mosh really is an exceptional instructor -- the best C# instructor on Udemy. I hope he will continue adding C# and .Net courses in the future. Anyway, I highly recommend this course!

Instructor

Mosh Hamedani
Passionate Software Engineer and Best-selling Author
Mosh Hamedani
  • 4.5 Instructor Rating
  • 205,696 Reviews
  • 489,890 Students
  • 20 Courses

Hi! My name is Mosh (Moshfegh) Hamedani! I'm a passionate software engineer with two decades of experience and I've taught over 3 million people who to code or how to become professional software engineers through my YouTube channel and online courses.

My goal is to make software engineering fun and accessible to everyone. That's why my courses are simple, pragmatic and free of BS.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.