Entity Framework: Getting Started (Complete Beginners Guide)
3.5 (30 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
117 students enrolled

Entity Framework: Getting Started (Complete Beginners Guide)

Learn how to connect your .NET C# Applications to SQL Server Database Using Entity Framework and its workflows.
3.5 (30 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
117 students enrolled
Last updated 6/2020
English
English [Auto]
Current price: $12.99 Original price: $49.99 Discount: 74% off
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • 4 articles
  • 10 downloadable resources
  • 1 Practice Test
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • What are the 3 Entity Framework workflows "Code First", "Model First" and "Database First" and how to use them
  • How to build .NET applications and connect to SQL Server using Entity Framework
  • What Entity Framework and Entity Framework Core are and how they work
  • The pros and cons of the 3 workflows and when it is best to use each one of them
  • How to build a C# Console App with Entity Framework Code First in Visual Studio
  • How to build a C# Windows Forms (GUI) App with Entity Framework Code First in Visual Studio
  • How to handle data model/database changes in Code First
  • How to build a C# Console App with Entity Framework Model First in Visual Studio
  • How to build a C# Windows Forms (GUI) App with Entity Framework Model First in Visual Studio
  • How to handle data model/database changes in Model First
  • How to build a C# Console App with Entity Framework Database First in Visual Studio
  • How to build a C# Windows Forms (GUI) App with Entity Framework Database First in Visual Studio
  • Handle data model/database changes in Database First
  • How to use Language-Integrated Query (LINQ-to-Entities) in C# to query data model entities
  • How to get started with Entity Framework Core on Linux
Course content
Expand all 51 lectures 05:01:02
+ Introduction to the Course
1 lecture 03:31

This is the introduction to the course. We will talk about how this course is structured and what will you learn after completing this course.

Preview 03:31
+ Introduction to Entity Framework
3 lectures 07:11

In this lecture, we will talk about what is Entity Framework and what are the benefits of using it.

Preview 03:11

In this lecture, you will learn how Entity Framework works and how makes it possible to offer an enhanced data access experience.

How Does Entity Framework Work?
02:59

This lecture, is a recap on what we’ve learned in this section.

What we’ve Learned in this Section
01:01

Test your knowledge on what was covered in this section!

Introduction to Entity Framework
5 questions
+ Entity Framework Concepts and Workflows
6 lectures 12:07

In this lecture, you will learn about the DbContext and DbSet classes, which are main components of the Entity Framework.

DbContext and DbSet
01:53

In this lecture, you will learn about Inheritance in Entity Framework.

Inheritance
01:59

In this lecture, you will learn about the Code First workflow in Entity Framework.

Code First
03:44

In this lecture, you will learn about the Model First workflow in Entity Framework.

Preview 01:59

In this lecture, you will learn about the Database First workflow in Entity Framework.

Database First
01:20

This lecture, is a recap on what we’ve learned in this section.

What we’ve Learned in this Section
01:12

Test what you've learned in the section "Entity Framework Concepts and Workflows"

Entity Framework Concepts and Workflows
5 questions
+ Full Guides - Let’s Build some Apps!
12 lectures 01:49:30

This lecture, presents the sample database that will be used for the demos. Moreover, it provides the relevant T-SQL DDL and DML script for creating the database, as a downloadable resource.

Before Building the Apps: Let's Create a Sample Database
02:27

In this demo/guide, we will see step by step, how we can build a .NET Console App in Visual Studio 2017, using the Code First workflow in Entity Framework along with creating a new database.

Build a .NET Console App Using Entity Framework Code First (New DB)
21:02

In this demo/guide, we will see step by step, how we can build a .NET Console App in Visual Studio 2017, using the Code First workflow in Entity Framework along with using an existing database.

Build a .NET Console App Using Entity Framework Code First (Existing DB)
11:50

In this demo/guide, we will see step by step, how we can build a .NET Windows Forms GUI App in Visual Studio 2017, using the Code First workflow in Entity Framework along with creating a new database.

Build a .NET Windows Forms App Using Entity Framework Code First (New DB)
13:38

In this demo/guide, we will see step by step, how we can build a .NET Windows Forms GUI App in Visual Studio 2017, using the Code First workflow in Entity Framework along with using an existing database.

Preview 08:52

This lecture, is a recap on what we’ve learned with the Code First demos.

What we’ve learned in the Code First Demos
00:53

In this demo/guide, we will see step by step, how we can build a .NET Console App in Visual Studio 2017, using the Model First workflow in Entity Framework.

Build a .NET Console App Using Entity Framework with Model First
17:26

In this demo/guide, we will see step by step, how we can build a .NET Windows Forms GUI App in Visual Studio 2017, using the Model First workflow in Entity Framework.

Build a .NET GUI App Using Entity Framework with Model First
11:38

This lecture, is a recap on what we’ve learned with the Model First demos.

What we’ve learned in the Model First Demos
00:50

In this demo/guide, we will see step by step, how we can build a .NET Console App in Visual Studio 2017, using the Database First workflow in Entity Framework.

Build a .NET Console App Using Entity Framework with Database First
10:44

In this demo/guide, we will see step by step, how we can build a .NET Windows Forms GUI App in Visual Studio 2017, using the Database First workflow in Entity Framework.

Build a .NET GUI App Using Entity Framework with Database First
09:43

This lecture, is a recap on what we’ve learned with the Database First demos.

What we’ve learned in the Database First Demos
00:27
+ Entity Framework Core on Windows (New)
3 lectures 19:41

A few words about this section.

About this Section
00:22

In this lecture and demo, we will learn more about Entity Framework Core and see how we can set up our environment for working with Entity Framework Core and .NET Core in Visual Studio.

Preview 08:28

In this lecture and demo, we will talk about the Fluent API in Code First and see how we can configure a Code First workflow in Entity Framework Core using the Fluent API.

Creating and Configuring a Model in Entity Framework Core Using Fluent API
10:51
+ Entity Framework Core on Linux (New)
10 lectures 49:43

This lecture, is an introduction of this new section in my course.

About this Section
01:49

In this lecture, we will talk about the supported Linux Distributions by SQL Server 2017 or later.

Supported Linux Distributions by SQL Server 2017 or later
00:56

In this demo, we are going to install SQL Server 2019 (currently CTP 3.0) on Ubuntu Linux 19.04.

How to Install SQL Server 2019 on Ubuntu Linux (Demo)
07:34

In this lecture, we will talk about the available SQL Server command-line tools in Linux.

Preview 01:06

In this lecture, we will install SQL Server command-line tools on Ubuntu Linux 19.04.

How to Install the SQL Server command-line tools on Ubuntu Linux (Demo)
04:53

In this lecture we will talk about Azure Data Studio and about its cross-platform characteristics.

Introducing Azure Data Studio: A Cross-Platform SQL Server Client Tool
02:00

In this demo, we will install and use Azure Data Studio on Ubuntu Linux 19.04.

How to Access SQL Server 2019 on Ubuntu Linux Using Azure Data Studio
09:00

In the lecture and demo, we will talk about .NET Core and install it on Ubuntu Linux 19.04.

Installing .NET Core
05:44

In this lecture and demo, we will talk about Database Providers for Entity Framework Core, and we will install the SQL Server provider on our Ubuntu Linux 19.04 test environment.

Entity Framework Database Providers
04:27

In this lecture and demo, on our Ubuntu Linux 19.04 test environment, we will create step-by-step, an Entity Framework Core project, using the Code-First workflow, along with creating a new database in SQL Server 2019 CTP 3.0 via Migrations.

Creating an Entity Framework Core Project on Linux (Code-First - New DB)
12:14
+ Staying Up to Date with Entity Framework (New)
2 lectures 14:27

Learn more about the upcoming release of Entity Framework 6.3.

Preview 00:42

In this lecture and demo, we will see how we can install Entity Framework 6.3 Preview with .NET Core 3.0 Preview 5 and how we can get started with using this new version of Entity Framework.

How to Install and Start Using Entity Framework 6.3 with .NET Core 3.0
13:45
+ Special Topics (New)
12 lectures 01:20:11

A few words about the addition of this new section (Special Topics).

Preview 00:24

In this special topic, we will create a sample database in order to be used in some of my subsequent special topics.

Create Sample Database for Special Topics Demos
03:38

In this article, we will be examining in more detail, Inheritance in Entity Framework. Also, with the use of a step-by-step example, we will see how we can use Inheritance when developing data apps with Entity Framework.

Example of Inheritance in Entity Framework
03:32

Via this live demonstration, you will learn how to install SQL Server and apply the basic configuration.

How to Install SQL Server
11:54

In this special topic, via live demonstrations, you will learn how you can connect to SQL Server using SQL Server Management Studio (SSMS).

Preview 01:53

In this special topic, you will learn via live demonstrations, how you can create databases and other objects in SQL Server using SSMS.

Creating a Database and Other Objects in SQL Server
09:04

In this lecture, via live demonstrations, you will learn how you can run queries against SQL Server using SSMS, and how you can script procedures to T-SQL.

Running Queries in SQL Server and Scripting Procedures to T-SQL
07:10

In this special topic, via live demonstrations, you will learn how you work with SQL Server, using Azure Data Studio.

Working with SQL Server using Azure Data Studio
03:57

In this lecture and demo, we will see how we can perform an offline installation of SQL Server 2019 (currently CTP 3.1) on Ubuntu Linux 19.04.

How to Perform an Offline Installation of SQL Server 2019 on Linux
11:47

In this special topic, we will see how we can import data in SQL Server using the OPENROWSET function.

How to Import Data in SQL Server Using the OPENROWSET Function
04:03

In this special topic, we will see how we can import and export data using SQL Server Integration Services (SSIS).

How to Import & Export Data Using SQL Server Integration Services (SSIS)
11:38

In this special topic, we will see how we can install SQL Server on CentOS Linux version 8.

How to Install SQL Server on CentOS Linux
11:10
+ Wrap-Up
1 lecture 01:16

This lecture, is a recap on what we've learned in this course.

What we’ve Learned in this Course
01:16

This is the main practice test for this course. It consists of 15 questions and can help you extensively test what you've learned in this course.

Entity Framework: Getting Started
15 questions
+ Learning More
1 lecture 03:24

Bonus lecture.

Bonus Lecture
03:24
Requirements
  • Basic Programming Principles
  • Basic C# Programming Language Knowledge
  • Basic Visual Studio Knowledge
Description

In this course, you will learn all about Entity Framework and Entity Framework Core on both Windows and Linux, what it is, how it works, what are its available workflows and their pros and cons. To this end, you will learn how to connect your C# Applications to SQL Server Database with Entity Framework and its workflows.


WHAT OTHER STUDENTS SAY ABOUT THE COURSE:

  • The course, and especially the live demos, help me start using Entity Framework easily.

  • I really enjoy this course. The instructor explains everything in simple words and the demos show step by step, how to start working with Entity Framework.

  • Cours très pertinent et complet. Touche aux différentes facettes d'approches de conception.

  • Thank you sir. This course helped me to better understand Framework!

  • Great learning experience, addressing the areas I expected to cover.


MORE ABOUT THE COURSE:

Entity Framework is an Object-Relational Mapper (ORM) development tool, that enables the Software Developer to write less data code faster, and focus more on the software logic instead of the underlying database.

Via this course and its large set of live demonstrations/guides, you will learn step-by-step, how you can efficiently build data applications using Visual Studio with C# and the different workflows of Entity Framework such as: Code First, Model First and Database First. Moreover, you will learn how to easily get started with Entity Framework Core on Linux.


AFTER THE COURSE:

  • You will know what Entity Framework and Entity Framework Core are and how they work

  • You will be able to create .NET Console and Windows Forms GUI data apps, using any of the available Entity Framework workflows:

    • Code First with Existing Database

    • Code First with New Database

    • Model First

    • Database First

  • You will be able to design .NET data applications much faster and you will be more productive.

  • You will be able to easily use Entity Framework when developing .NET data apps

  • You will be able to start working with Entity Framework Core on both Windows and Linux


PREREQUISITES:

  • Basic Programming Principles

  • Basic C# Programming Language Knowledge

  • Good to know: Microsoft® Visual Studio®

  • In this course, we will be working with .NET Framework (C#) on Windows® and Entity Framework 6 via Microsoft® Visual Studio® 2017

  • Also, we will be working with Entity Framework Core 2.2 SDK on Ubuntu® Linux.


THIS COURSE CONTAINS/OFFERS:

  • 5 hours of high-quality video lectures

  • Step by step live demonstrations and guides that can help you get started with Entity Framework and Entity Framework Core in no time

  • Downloadable resources with useful information and links

  • Downloadable infographics that will help you better understand the main concepts of Entity Framework

  • Useful practice tests/quizzes for testing your knowledge on each section

  • A major practice test in the end of the course

  • Ability to ask the instructor questions via the Q&A section

  • Certificate on course completion


Also: This course is being updated with new educational material on a regular basis.

Who this course is for:
  • People that develop data applications in .NET and want to be more productive
  • People that want to start using the Entity Framework for building robust .NET data applications
  • .NET Software Developers that want to just focus on building the software, and not the database
  • Technology enthusiasts that want to learn more about software development and .NET