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

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

by Trevoir Williams
Released September 2021
Publisher(s): Packt Publishing
ISBN: 9781803242231

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

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.

What You Will Learn

  • Know the differences between database-first and code-first workflows
  • Use migrations to manage changes to your database
  • Use Fluent API to manage constraints and design
  • Implement database relationships
  • Understand change tracking and conduct RAW SQL queries
  • Execute stored procedures, functions, view queries

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.

About The Author

Trevoir Williams: Trevoir Williams is a software engineer and part-time lecturer. With a master’s degree in computer science, he has spent over a decade teaching web, software, and database development courses. He also has extensive industry experience in web application development, Azure Cloud system, and server administration.

He enjoys teaching IT and development courses and hopes to impart knowledge of the latest developments in industry standards and techniques to his students.

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