Hands On C# .Net: Entity Framework Core

Complete Entity Framework Core Course: Covering Key Concepts, Performance, and Practical Exercises

What you'll learn

Create databases based on C# classes.

Write efficient database queries using LINQ.

Apply database schema changes through migrations

Manage data and operate on data sets

Requirements

Proficiency in C#

Description

Master Entity Framework Core: Comprehensive Course with Practical Exercises and Performance OptimizationCreating various types of applications—whether mobile, web, or desktop—almost always requires a robust database to store and manage data efficiently.While you could learn SQL to write and send queries directly to a database, this approach is often error-prone and makes code maintenance challenging and time-consuming.A smarter and more efficient solution is to use an ORM (Object-Relational Mapping) tool. An ORM simplifies database communication by allowing you to work with C# objects, which serve as an abstraction of the underlying database, streamlining development and reducing errors.Entity Framework Core (EF Core) stands out as the most popular .NET ORM, trusted by developers worldwide with over 800 million downloads. Its versatility and power make it a go-to choice for building scalable and high-performance applications.Hi, I’m Jakub Kozera, a passionate .NET expert, and in this comprehensive EF Core course, I’ll guide you through mastering database operations using EF Core—from foundational concepts to advanced techniques.What You’ll Learn in This CourseCore Mechanics and Principles: Understand the inner workings of EF Core, its capabilities, and its limitations to make informed decisions in your projects.Database Creation: Learn to design C# classes that automatically generate a database and configure them to create a table schema that aligns perfectly with your vision.Entity Relationships: Set up relationships between C# entities to establish seamless database relations, ensuring data integrity and consistency.Database Migrations: Master database migrations to evolve your database schema as your application grows, with practical strategies for managing changes effectively.Data Seeding: Implement data seeding to pre-populate your database with essential data, ensuring your application is ready to go from its first launch.CRUD Operations: Gain hands-on experience with adding, deleting, and modifying records to manage table data efficiently.Efficient Queries: Write optimized queries to retrieve data with minimal performance overhead, boosting your application’s speed and responsiveness.Advanced Features: Dive into lazy loading, built-in types, view support, and other advanced EF Core functionalities to unlock its full potential.Performance Optimization: Explore EF Core’s performance, identify common challenges, and apply proven techniques to resolve performance bottlenecks.Practical Exercises: Reinforce your learning with hands-on exercises designed to solidify your understanding and build real-world skills.Why Choose This Course?Whether you’re a beginner just starting with EF Core or an experienced developer looking to refine your skills, this course is tailored to help you succeed. By the end, you’ll be able to:Use EF Core confidently to build robust, scalable applications.Optimize database performance to ensure your applications run smoothly.Apply best practices to avoid common pitfalls and streamline development.Added Value for Your Learning JourneyBeyond the core curriculum, this course includes real-world case studies and expert tips from my years of experience as a .NET developer. You’ll also gain access to a community of learners where you can share insights, ask questions, and grow your network. Plus, the course is regularly updated to reflect the latest EF Core features and industry trends, ensuring you stay ahead in the fast-evolving world of .NET development.This course is your ultimate guide to mastering Entity Framework Core, .NET database development, ORM best practices, database performance optimization, and C# programming. Whether you’re building web applications, mobile apps, or desktop software, this course equips you with the skills to create high-performance, scalable, and maintainable database-driven solutions.Enroll today and take the first step toward becoming an EF Core expert! By the end of this course, you’ll wield Entity Framework Core with confidence, delivering high-quality applications without worrying about database performance.

Overview

Section 1: Introduction

Lecture 1 Intro

Lecture 2 What is Entity Framework and how does it work

Lecture 3 Source code

Section 2: Creating databases - Code first approach

Lecture 4 Presentation of the target project idea

Lecture 5 Creating minimal API project

Lecture 6 Database entities creation

Lecture 7 DbContext and configuration

Lecture 8 Primary keys

Lecture 9 Entity configuration

Lecture 10 Default values

Lecture 11 One to one relation

Lecture 12 One to many relation

Lecture 13 Many to many relation

Lecture 14 Practical exercise - relations

Lecture 15 Inheritance

Section 3: Migrations

Lecture 16 First migration

Lecture 17 How migrations work

Lecture 18 Custom migrations

Lecture 19 Applying migrations

Lecture 20 Undoing migration

Lecture 21 Practical exercise - migration

Section 4: Data seeding

Lecture 22 Model data seed

Lecture 23 Manual migration adjustment

Lecture 24 Custom seeding logic

Lecture 25 Practical exercise - seeding

Section 5: Queries

Lecture 26 Sample queries

Lecture 27 Practical exercise - queries

Lecture 28 How queries work

Lecture 29 Updating data

Lecture 30 Adding data

Lecture 31 Loading related data

Lecture 32 Deleting data

Lecture 33 Cascade delete on EF side

Lecture 34 Change tracking

Lecture 35 Change tracking - benchmark

Section 6: Advanced topics

Lecture 36 Raw SQL queries

Lecture 37 View [Keyless]

Lecture 38 Owned types

Lecture 39 Lazy loading

Lecture 40 Lazy loading - my opinion

Lecture 41 Results pagination

Lecture 42 Grouping configuration

Lecture 43 Scaffolding existing database

Section 7: Entity Framework performance

Lecture 44 Indexes

Lecture 45 Select operator

Lecture 46 n + 1 problem

Lecture 47 Overusing Include

Lecture 48 Bulk update intro

Lecture 49 Bulk update prior EF Core 7

Lecture 50 Bulk update in EF Core 7+

Section 8: Extras

Lecture 51 Realistic Data Generation - Bogus

Lecture 52 Sieve

Lecture 53 Whats new in Entity Framework Core 8

People who program in C# and want to learn how to communicate with a database using Entity Framework