4.54 out of 5
4.54
13 reviews on Udemy

Entity Framework: Getting Started (Ultimate Beginners Guide)

Connect your .NET C# apps to SQL Server databases and efficiently access data via the Entity Framework and its workflows
Instructor:
Artemakis Artemiou
39 students enrolled
Understand what Entity Framework is and how it works
Learn all about the Entity Data Model is in Entity Framework
Learn about the 3 Entity Framework workflows "Code First", "Model First" and "Database first"
Learn about the pros and cons of the 3 workflows and when it is best to use each one of them
Build in Visual Studio a C# Console App with Entity Framework Code First
Build in Visual Studio a C# Windows Forms (GUI) App with Entity Framework Code First
Learn how to handle data model/database changes in Code First
Build in Visual Studio a C# Console App with Entity Framework Model First
Build in Visual Studio a C# Windows Forms (GUI) App with Entity Framework Model First
Learn how to handle data model/database changes in Model First
Build in Visual Studio a C# Console App with Entity Framework Database First
Build in Visual Studio a C# Windows Forms (GUI) App with Entity Framework Database First
Learn how to handle data model/database changes in Database First
Learn how to use Language-Integrated Query (LINQ-to-Entities) in C# to query data model entities

Would you like to learn how to easily develop .NET data applications that interact with SQL Server, without really having to manually design a database?

Would you like instead of having to worry about the database, to just focus on the application logic and .NET code development and let a free .NET special tool take care of the database creation process?

If the answer to the above questions is “Yes“, then you should definitely enroll to my course.

My name is Artemakis Artemiou and I’m a Senior SQL Server & Software Architect with over than 15 years of experience on SQL Server administration, development, performance tuning and architecture, as well as on .NET development (C#).  Moreover, I’m a former Microsoft Data Platform MVP (2009-2018). I love talking about SQL Server, .NET, data access, and related topics, and make it easy for all to understand, by using a simple and understandable language as well as analytical guides.

WHAT IS THIS COURSE ALL ABOUT?

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.

In this course, you will learn all about Entity Framework, what it is, how it works, what are its available workflows and their pros and cons. Then, we will jump into a large set of live demonstrations/guides, that show you 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.

This is the ultimate beginners guide to Entity Framework.

AFTER THE COURSE:

  • You will know what Entity Framework is and how it works

  • 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

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

100% MONEY-BACK GUARANTEE

This course comes with a 30-day money back guarantee. If you’re not satisfied with this course, you can ask for a refund.

THIS COURSE CONTAINS/OFFERS:

  • 2.5 hours of high-quality video

  • Step by step live demonstrations and guides that can help you get started with Entity Framework 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

  • 30-day no-questions-asked refund policy

  • Certificate on course completion

Introduction to the Course

1
Welcome to the Course!

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.

Introduction to Entity Framework

1
What is Entity Framework?

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

2
How Does Entity Framework Work?

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

3
What we’ve Learned in this Section

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

4
Introduction to Entity Framework

Test your knowledge on what was covered in this section!

Entity Framework Concepts and Workflows

1
DbContext and DbSet

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

2
Inheritance

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

3
Code First

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

4
Model First

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

5
Database First

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

6
What we’ve Learned in this Section

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

7
Entity Framework Concepts and Workflows

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

Full Guides - Let’s Build some Apps!

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

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.

2
Build a .NET Console App Using Entity Framework Code First (New DB)

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.

3
Build a .NET Console App Using Entity Framework Code First (Existing DB)

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.

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

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.

5
Build a .NET Windows Forms App Using Entity Framework Code First (Existing DB)

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.

6
What we’ve learned in the Code First Demos

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

7
Build a .NET Console App Using Entity Framework with Model First

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.

8
Build a .NET GUI App Using Entity Framework with Model First

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.

9
What we’ve learned in the Model First Demos

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

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

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.

11
Build a .NET GUI App Using Entity Framework with Database First

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.

12
What we’ve learned in the Database First Demos

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

Special Topics (New)

1
About Special Topics

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

2
Example of Inheritance in Entity Framework

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.

3
How to Install SQL Server

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

4
Connecting to SQL Server via SSMS

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

5
Creating a Database and Other Objects in SQL Server

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

6
Running Queries in SQL Server and Scripting Procedures to T-SQL

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.

7
Working with SQL Server using Azure Data Studio

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

Wrap-Up

1
What we’ve Learned in this Course

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

2
Entity Framework: Getting Started

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.

Learning More

1
Bonus Lecture

Bonus lecture, with next steps on learning more about Entity Framework and related technologies, as well as exclusive coupons for my other courses.

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.5
4.5 out of 5
13 Ratings

Detailed Rating

Stars 5
10
Stars 4
1
Stars 3
1
Stars 2
0
Stars 1
1
3f0853ea451f0319e1f50935ab19c8c4
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
2 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion