Entity Framework Core — A Full Tour (.NET 5 and up)

Video description

Learn how to use and take advantage of the full feature set of Entity Framework Core in your .NET applications

About This Video

  • Construct a data model using code-first and database-first workflows
  • Understand Entity Framework commands
  • Handle one-to-one, one-to-many, and many-to-many relationships

In Detail

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

In this course, we will review the general benefits of using Entity Framework Core 5, 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 spend time discovering 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.

By the end of this course, you will have the skills and knowledge of Entity Framework Core needed to fluidly interact with data and write queries for .NET Core applications with ease.

Audience

This course is for students who want to learn Entity Framework in a hands-on way. In order to take this course, you should have at least three months' experience of programming in C#. If you need to strengthen your C# fundamentals, you can take the C# beginner course, C# Console and Windows Forms Development with LINQ and ADO.NET.

Publisher resources

Download Example Code

Table of contents

  1. Chapter 1 : Introduction
    1. Welcome to the Course
  2. Chapter 2 : Getting Started with Entity Framework Core
    1. Set Up Development Environment
    2. Setting Up the Solution
    3. Creating the Data Models with EF Core
    4. Specifying the Data Provider and Connection String
    5. Migrations and Database Creation
    6. Generate Migration Scripts
    7. Reverse Engineer Existing Database
  3. Chapter 3 : Interact with Your Database
    1. View Diagram with Entity Framework Core Tools
    2. Adding Verbose Logging to EF Core's Workload
    3. Simple Insert Operations
    4. Simple Select Operations
    5. Filtering Records
    6. Additional Execution Methods
    7. Alternative LINQ Syntax
    8. Simple Update Query
    9. Simple Delete Query
    10. Tracking Versus No Tracking
  4. Chapter 4 : Interacting with Related Records
    1. Review One-to-Many Relationships
    2. Adding Many-to-Many Relationships
    3. Adding One-to-One Relationships
    4. Generate New Entity Diagram
    5. Inserting Related Data
    6. (Eager Loading) Including Related Data
    7. Projections and Anonymous Data Types
    8. Filtering on Related Records
  5. Chapter 5 : Working with Views, Stored Procedures, and Raw SQL
    1. Adding Views and Other Data Objects
    2. Querying Keyless Entities (Like Views)
    3. Querying with Raw SQL
    4. Add and Query Using Stored Procedures
    5. Executing Non-Query Raw SQL
  6. Chapter 6 : Additional Common Tasks
    1. Seeding Data
    2. Rolling Back Migrations
    3. Manipulate Entries Before Saving Changes
    4. Extending DbContext
    5. Implement Full Database Auditing
    6. Implement Full Database Auditing - Fix
    7. Data Validation with Data Annotations
    8. Fully Using Configuration Files
    9. Support For Database Transactions
    10. Database Connection Retry Policy
  7. Chapter 7 : Entity Framework Core 6 Features
    1. What is EF Core 6 and How do I Get It?
    2. Upgrade to EF Core 6
    3. Pre-convention model configuration
    4. SQL Server Temporal Tables
  8. Chapter 8 : Conclusion
    1. Conclusion

Product information

  • Title: Entity Framework Core — A Full Tour (.NET 5 and up)
  • Author(s): Trevoir Williams
  • Release date: September 2021
  • Publisher(s): Packt Publishing
  • ISBN: 9781803242231