Entity Framework Core - A Full Tour from Udemy

Overview

In this course, Entity Framework Core - A Full Tour, you will learn to work with data in your .NET applications.

When courses are created for .NET technologies, the details of Entity Framework and its sheer power are often neglected. We get distracted with abstractions and layers and need to focus on what Entity Framework is doing and can do.

In this course, we will review the general benefits of using Entity Framework Core, which is Microsoft’s flagship Object Relational Mapper (ORM), to relieve you of many concerns and challenges that come with this component of software development. We will also discover how EF Core translates classes and references to Database Models and Relationships.

We will learn how to write queries, update databases incrementally, roll back changes, and explore the myriad capabilities that Entity Framework Core affords us. This course is compatible with .NET 6 / .NET 7 / .NET 8.

When you finish this course, you’ll have the skills and knowledge of Entity Framework Core needed to easily interact with data and write queries for .NET Core applications.

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

Construct a data model using code-first and database-first workflows.
Understand Entity Framework Commands for all operating systems.
Use migrations to manage database changes.
Apply Database validations and constraints.
Perform CRUD operations using LINQ.
Apply best practices with Entity Framework.
Extending Data Contexts
Understand how Change Tracking works.
Manage Database Structure using Fluent API
Handle One-To-One, One-To-Many and Many-To-Many Relationships
Entity Framework Core 6 New Features

If you need to strengthen your C# fundamentals, you can take my C# beginner course C# Console and Windows Forms Development with LINQ & ADO .NET

You can also explore Database Development, which you can look at in the Complete Microsoft SQL Server Database Design Masterclass course.

Content and Overview

To take this course, you will need to know C#. Even if you have little exposure to the .NET development stack, this course is beginner-friendly and has development tips.

This premium course is smartly broken up to highlight related activities based on each module in the application being built. We will also look at troubleshooting and debugging errors as we go along, implementing best practices, writing efficient logic, and understanding why developers do things the way they do. Your knowledge will grow, step by step, throughout the course, and you will be challenged to be the best you can be.

The course is complete with working files hosted on GitHub, including some files to make it easier for you to replicate the demonstrated code. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.

Clicking the Take This Course button could be the best step to increase your income and marketability quickly. Also, remember that if you think the course is not worth your spending, you have a full 30 days to get a no-questions-asked refund.

It's time to take action.

See you in the course.

What's inside

Learning objectives

Entity framework core - in depth
Understand the differences between database-first and code-first workflows
Use migrations to manage changes to your database
Apply best practices with entity framework
Query data using linq (using query syntax and extension methods)

Use fluent api to manage constraints and design
Implement database relationships
Understand change tracking
Conduct raw sql queries
Execute stored procedures, functions, view queries

Entity framework core - in depth
Understand the differences between database-first and code-first workflows
Use migrations to manage changes to your database
Apply best practices with entity framework
Query data using linq (using query syntax and extension methods)
Use fluent api to manage constraints and design
Implement database relationships
Understand change tracking
Conduct raw sql queries
Execute stored procedures, functions, view queries

Syllabus

Introduction

IMPORTANT - .NET 8 Update

What is Entity Framework Core?

Environment Setup

Toolset Overview

Install Visual Studio - Windows

Install Visual Studio Code

Install .NET Core and EF Core Tools

Getting Started with Entity Framework Core

Section Overview

Setup Project Solution - Visual Studio

Setup Project Solution - Visual Studio Code + Dotnet CLI

What are Data Models?

Creating the Data Models with EF Core

Understanding the Database Context

Adding a Database Context

EF Core and Database Support

Specifying the Data Provider and Connection String

Understanding Code First Development and Migrations

Setup Console App Project

Adding a Migration

Generating a Database (Code-First)

Understanding Database First Development

Reverse Engineer Existing Database

Seeding Data

Section Review

Section Source Code

Using Entity Framework Core to Query a Database

Adding Verbose Logging to EF Core’s Workload

Fix: Database Connection String Refactor

LINQ as Entity Framework Core Syntax

Querying Basics

Synchronous vs. Asynchronous Syntax

Querying for a Single Record

Add Filters to Queries

Additional Filtering Features

Alternative LINQ Syntax

Aggregate Methods

Group By

Order By

Skip and Take

Projections and Custom Data Types

Tracking Vs. No Tracking (Enhancing Performance)

IQueryables vs List Types

Efficient Querying Tips and Tricks

Using Entity Framework Core to Manipulate Data

Understanding Tracking and Saving Changes

Simple Insert Operations

Simple Update Operations

Simple Delete Operations

ExecuteUpdate and ExecuteDelete (>= EF Core 7)

Handling Database Changes and Migrations

Review Entity Framework Core Migrations

Adding More Entities

Updating Database with Migration(s)

Using Configuration Files

Generating Migration Scripts

Rolling Back Migrations and Database Changes

EF Bundles

Applying Migrations at Runtime

Interacting With Related Records

Database Relationships and Entity Framework Core

One to Many Relationships

Adding One-To-Many Relationships

View Diagram with Entity Framework Core Tools

Many to Many Relationships

Adding Many-To-Many Relationships

Understanding One-To-One Relationships

Adding One-To-One Relationships

Update Database With Relationships

Inserting Related Data

Eager loading, lazy Loading and Explicit Loading

Including Related Data with Eager Loading

Including Related Data with Explicit Loading

Including Related Data with Lazy Loading

Filtering on Related Records

Projections and Anonymous Data Types

Understanding Delete Behaviors

Working With Raw SQL, Views and Stored Procedures

Adding Non-Table Objects with Migrations

Querying Keyless Entities (Like Views)

Querying with Raw SQL - Part 1

Querying with Raw SQL - Part 2

Querying scalar

Executing User-defined Funcitons

Limitations of Raw Queries and EF Core

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Covers core concepts in Entity Framework Core, including code-first and database-first workflows, migrations, best practices, and LINQ queries. Suitable for beginners with some C# experience

Taught by seasoned Python expert Trevoir Williams, who brings industry knowledge and practical experience to the course

Provides hands-on experience through a step-by-step approach, including the creation of a working application throughout the course

Covers essential database concepts, such as relationships, constraints, and data manipulation, making it suitable for those looking to enhance their database skills

Introduces advanced topics like fluent API and change tracking, suitable for developers seeking to deepen their understanding of Entity Framework Core

Encourages learners to be resourceful by providing links to additional resources, GitHub files, and troubleshooting tips

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Entity Framework Core - A Full Tour with these activities:

Review Entity-Relationship Modeling (ERM) Fundamentals

Show steps

Refresh your understanding of ERM principles to enhance your comprehension of Entity Framework Core concepts.

Browse courses on Database Design

Show steps

Review resources on ERM concepts, such as entities, attributes, and relationships.
Identify the entities and relationships in a sample business scenario.
Draw an ERD (Entity-Relationship Diagram) to visualize the data model.

Explore Entity Framework Core Documentation

Show steps

Familiarize yourself with the official Entity Framework Core documentation, which provides comprehensive information and examples to enhance your understanding of the framework's features and usage.

Browse courses on Entity Framework Core

Show steps

Review Entity Framework Core Overview
Explore Code-First and Database-First Approaches
Understand Entity Framework Core Data Modeling

Create an Entity Framework Core Resource List

Show steps

Create a list of resources for learning about Entity Framework Core.

Browse courses on Entity Framework Core

Show steps

Find resources about Entity Framework Core.
Evaluate the resources.
Organize the resources into a list.
Share the list with other students.

13 other activities

Expand to see all activities and additional details

Show all 16 activities

Join a Study Group

Show steps

Join a study group to discuss Entity Framework Core and other data access topics.

Browse courses on Entity Framework Core

Show steps

Find a study group to join.
Attend study group meetings.
Participate in discussions.
Help other students.

EF Core Tutorial Series

Show steps

Follow a series of guided tutorials to learn the basics of Entity Framework Core and its features

Browse courses on Entity Framework Core

Show steps

Find a reputable online resource or platform offering tutorials on EF Core
Start with the introductory tutorials and work your way through the series
Follow the instructions and code examples provided in the tutorials
Experiment with the code and try different scenarios to reinforce your understanding
Complete the exercises and assignments included in the tutorials

Complete Official Microsoft Entity Framework Core Tutorial

Show steps

Gain hands-on experience with Entity Framework Core by following Microsoft's comprehensive tutorial.

Show steps

Set up your development environment and install Entity Framework Core.
Create a new project and database using Code-First approach.
Add and manipulate data using LINQ queries.
Apply Entity Framework Core best practices, such as dependency injection.

Entity Framework Core Code Generation Exercises

Show steps

Solve coding exercises that focus on Entity Framework Core code generation, solidifying your understanding of how to generate database schemas and interact with your data model using code.

Browse courses on Entity Framework Core

Show steps

Follow Code-First Development Practice
Generate Database Schema from Code
Query and Modify Data Using Code

LINQ Practice

Show steps

Practice using LINQ to query data in Entity Framework Core.

Browse courses on LINQ

Show steps

Create a new console application.
Install Entity Framework Core.
Create a model class to represent your data.
Create a DbContext class to manage your database connection.
Use LINQ to query your data.

Develop a Simple Web Application Using Entity Framework Core

Show steps

Build a project to reinforce your understanding of Entity Framework Core, practicing the skills learned throughout the course to create a functioning web application that leverages data persistence.

Browse courses on Entity Framework Core

Show steps

Design and Plan Your Application
Create a New ASP.NET Core Web Application
Add Entity Framework Core to Your Project
Create Your Database Model and Entities
Perform CRUD Operations Using Entity Framework Core

Study Group

Show steps

Studying with a group allows for collaboration and helps solidify understanding of topics covered in this course

Browse courses on Entity Framework Core

Show steps

Find a group of classmates interested in studying together
Meet regularly to discuss course material, go over practice problems, and quiz each other
Take turns leading the study sessions and presenting the material
Use whiteboards, diagrams, and other visual aids to help explain concepts
Review notes and assignments together before exams and quizzes

Query Practice

Show steps

Practice writing queries using Entity Framework Core and LINQ to improve proficiency and fluency

Browse courses on LINQ

Show steps

Find a set of practice problems or exercises online or in textbooks
Work through the problems step-by-step, writing and executing the queries
Check your answers against provided solutions or consult with classmates or instructors for feedback
Repeat the process with different types of queries and scenarios
Time yourself to improve efficiency and speed

Solve Entity Framework Core Code Challenges

Show steps

Test your understanding of Entity Framework Core concepts through practical coding exercises.

Show steps

Find coding challenges online or in books specifically designed for Entity Framework Core.
Attempt to solve the challenges on your own, referring to documentation or other resources as needed.
Review your solutions and learn from any mistakes.

Build a Simple CRUD Application with Entity Framework Core

Show steps

Apply your Entity Framework Core skills to create a functional CRUD (Create, Read, Update, Delete) application.

Show steps

Design the database schema and entities.
Implement data access layer using Entity Framework Core.
Create a user interface for managing data.
Test the application thoroughly.

Build a Blog Application

Show steps

Build a complete web application using Entity Framework Core to manage your data.

Browse courses on Entity Framework Core

Show steps

Create a new ASP.NET Core project.
Install Entity Framework Core.
Create a model class to represent your data.
Create a DbContext class to manage your database connection.
Create a controller to handle your web requests.
Create a view to display your data.

Write a Blog Post on Entity Framework Core Best Practices

Show steps

Demonstrate your knowledge and understanding of Entity Framework Core best practices by creating a comprehensive blog post that shares insights and guidelines for optimizing your data access and data manipulation strategies.

Browse courses on Entity Framework Core

Show steps

Research and Gather Information
Outline Your Blog Post
Write and Edit Your Content
Publish and Promote Your Blog Post

Write a Technical Blog Post

Show steps

Write a technical blog post about your experience using Entity Framework Core.

Browse courses on Entity Framework Core

Show steps

Choose a topic to write about.
Research your topic.
Write your blog post.
Edit and proofread your blog post.
Publish your blog post.

Career center

Learners who complete Entity Framework Core - A Full Tour will develop knowledge and skills that may be useful to these careers:

Reading list

We haven't picked any books for this reading list yet.

Entity Framework Core - A Full Tour

Here's a deal for you

What's inside

Learning objectives

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses