We may earn an affiliate commission when you visit our partners.
Course image
Trevoir Williams

Overview

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

Read more

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.

Enroll now

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

Syllabus

Introduction
IMPORTANT - .NET 8 Update
What is Entity Framework Core?
Environment Setup
Read more
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

Save this course

Save Entity Framework Core - A Full Tour to your list so you can find it easily later:
Save

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Entity Framework Core - A Full Tour.
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser