Hands On C# .Net: Entity Framework Core
 

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