EF Core 8 Fundamentals

سرفصل های دوره

This course will teach you how to use Entity Framework Core to perform data access in your .NET applications.

1. Course Overview

1. Course Overview

2. Creating Your First Application Using EF Core

1. Introduction and Overview

2. What Is Entity Framework Core

3. Getting the Correct Versions of .NET, SQL Server and Visual Studio for this Course

4. Introducing the Project

5. Creating a Data Project with EF Core Packages

6. Creating the Data Model with EF Core

7. Specifying the Data Provider and Connection String

8. Reading and Writing Some Data

9. Reading and Writing Some Related Data

10. Review and Resources

3. Using EF Core to Query a Database

1. Introduction and Overview

2. Querying Basics

3. Filtering Queries Securely by Default

4. Benefiting from Additional Filtering Features

5. Sorting Data in Queries

6. Aggregating Results in Queries

7. Enhancing Query Performance When Tracking Isnt Needed

8. Review and Resources

4. Tracking and Saving Data with EF Core

1. Introduction and Overview

2. Gaining a Better Understanding of DbContext and Entity

3. Understanding Tracking and Saving Workflow

4. Inserting Simple Objects

5. Updating Simple Objects

6. Updating Untracked Objects

7. Deleting Simple Objects

8. Tracking Multiple Objects and Batch Support

9. Updating and Deleting Multiple Untracked Objects

10. Review and Resources

5. Controlling Database Creation and Schema with Migrations

1. Introduction and Overview

2. Understanding EF Core Migrations

3. Getting and Understanding the Design-Time Migrations Tools

4. Getting the Package Manager Console Ready to Use Migrations

5. Adding Your First Migration

6. Inspecting Your First Migration

7. Using Migrations to Script or Directly Create the Database

8. Seeding a Database via Migrations

9. Scripting Multiple Migrations

10. Reverse Engineering an Existing Database

11. Review and Resources

6. Defining One-to-Many Relationships

1. Introduction and Overview

2. Visualizing EF Cores Interpretation of Your Data Model

3. Interpreting One-to-Many Relationships

4. Benefiting from Foreign Key Properties

5. Mapping Unconventional Foreign Keys

6. Understanding Nullability and Required vs. Optional Principals

7. Review and Resources

7. Logging EF Core Activity and SQL

1. Introduction and Overview

2. Adding Logging to EF Cores Workflow

3. Filtering Log Output with EF Core Message Categories and LogLevel

4. Additional Filtering Capabilities

5. Specifying the Target of the Log Output

6. Review and Resources

8. Interacting with Related Data

1. Introduction and Overview

2. Adding Related Data

3. Eager Loading Related Data in Queries

4. Projecting Related Data in Queries

5. Loading Related Data for Objects Already in Memory

6. Using Lazy Loading to Retrieve Related Data

7. Using Related Data to Filter Objects

8. Modifying Related Data

9. Understanding Deleting Within Graphs

10. Review and Resources

9. Defining and Using Many-to-Many Relationships

1. Introduction and Overview

2. Planning the Many-to-Many Implementation

3. Understanding and Creating Skip Navigations

4. Joining Objects in New Many-to-Many Relationships

5. Querying Across Many-to-Many Relationships

6. Understanding and Benefiting From Circular References in Graphs

7. Removing Joins in Many-to-Many Relationships

8. Changing Joins in Many-to-Many Relationships

9. Introducing More Complex Many-to-Many Relationships

10. Review and Resources

10. Defining and Using One-to-One Relationships

1. Introduction and Overview

2. Understanding How EF Core Discovers One-to-One Relationships

3. Updating the Model and Database with the New Relationship

4. Querying One-to-One Relationships

5. Combining Objects in One-to-One Relationships

6. Replacing or Removing One-to-One Relationships

7. Review and Resources

11. Working with SQL, Views, and Stored Procedures

1. Introduction and Overview

2. Querying with SQL

3. Keeping Your Database Safe with Parameterized Raw SQL Queries

4. Adding Stored Procedures and Other Database Objects Using Migrations

5. Running Stored Procedure Queries with Raw SQL

6. Querying for Scalars and Other Non-Entity Types

7. Using Keyless Entities to Map to Views

8. Querying the Database Views

9. Executing Non-Query SQL Commands

10. Mapping Insert, Update, and Delete Stored Procedures to Entities

11. Review and Resources

12. Using EF Core in ASP.NET Core Apps

1. Introduction and Overview

2. Reviewing EF Cores Lifecycle in Disconnected Apps

3. Adding the ASP.NET Core Project

4. Creating Author Endpoints for the API

5. Wiring up the ASP.NET Core App with the DbContext

6. Running the API to See the Output and Logs

7. Refactoring the API to Align with Common Practices Using DTOs

8. Exploring and Debugging Insert, Update & Delete API Methods

9. Review and Resources

13. Testing with EF Core

1. Introduction and Overview

2. A Very Quick Testing Overview

3. Understanding What We Mean by Testing EF Core

4. Preparing the DbContext

5. Creating Your First Test and Using It Against the Database

6. Exploring Test Results and Performance Considerations

7. Testing with SQLite in Memory

8. Refactoring and Testing Some Console App Logic

9. Testing the ASP.NET Core API

10. Testing Endpoints That Use EF Core

11. Review and Resources

14. Adding Some More Practical Mappings to Your Application

1. Introduction and Overview

2. Understanding How Project Nullability Affects EF Cores String Mappings

3. Learning Some Additional Common Conventions and Mappings

4. Using Data Annotations to Describe Mappings

5. Storing Sub-Types and Primitive Collections as JSON

6. Mapping Unmappable Property Types with Value Conversions

7. Applying Bulk Configurations and Conversions

8. Mapping Complex Types and DDD Value Objects

9. Review and Resources

15. Understanding EF Cores Database Connectivity

1. Introduction and Overview(1)

2. Recognizing the Many Database Providers Available for EF Core

3. Highlights of the Azure Cosmos DB Provider

4. EF Cores Transaction Support and Concurrency Handling

5. Answering Some DB Connection FAQs

6. Review and Resources

16. Tapping into EF Cores Pipeline

1. Introduction and Overview

2. Exploring ChangeTracker Entries for Overriding the SaveChanges Method

3. Updating Shadow Properties During SaveChanges

4. Using EF Core Pipeline Events

5. Using Interceptors to Inject Logic into EF Cores Pipeline

6. Review and Resources

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight