EF Core 6 Fundamentals

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

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

1. Course Overview

1. Course Overview

02. Building Your First Application using EF Core

01. Introduction and Course Overview

02. What Is Entity Framework Core

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

04. Introducing the Project

05. Creating a Data Project with EF Core 6 Packages

06. Creating the Data Model with EF Core

07. Specifying the Data Provider and Connection String

08. Reading and Writing Some Data

09. Reading and Writing Some Related Data

10. Review and Resources

3. Using EF Core 6 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 Bulk Support

9. Review and Resources

05. Controlling Database Creation and Schema with Migrations

01. Introduction and Overview

02. Understanding EF Core Migrations

03. Getting and Understanding the Design-Time Migrations Tools

04. Getting the Package Manager Console Ready to Use Migrations

05. Adding Your First Migration

06. Inspecting Your First Migration

07. Using Migrations to Script or Directly Create the Database

08. Seeding a Database via Migrations

09. 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. Benefitting 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

08. Interacting with Related Data

01. Introduction and Overview

02. Adding Related Data

03. Eager Loading Related Data in Queries

04. Projecting Related Data in Queries

05. Loading Related Data for Objects Already in Memory

06. Using Lazy Loading to Retrieve Related Data

07. Using Related Data to Filter Objects

08. Modifying Related Data

09. Understanding Deleting Within Graphs

10. Review and Resources

09. Defining and Using Many-to-Many Relationships

01. Introduction and Overview

02. Planning the Many-to-Many Implementation

03. Understanding and Creating Skip Navigations

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

05. Querying Across Many-to-Many Relationships

06. Understanding and Benefiting From Circular References in Graphs

07. Removing Joins in Many-to-Many Relationships

08. Changing Joins in Many-to-Many Relationships

09. 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 Views and Stored Procedures and Raw SQL

1. Introduction and Overview

2. Querying with Raw 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. Using Keyless Entities to Map to Views

7. Querying the Database Views

8. Executing Non-Query Raw SQL Commands

9. Review and Resources

12. Using EF Core with ASP.NET Core Apps

01. Introduction and Overview

02. Reviewing EF Cores Lifecycle in Disconnected Apps

03. Adding the ASP.NET Core Project

04. Adding an Author Controller to the Project

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

06. Running the Controller to See the Output and Logs

07. Refactoring the Controller to Align with Common Practices

08. Exploring and Debugging Insert, Update & Delete Controller Methods

09. Using Raw SQL for Controller Methods

10. Review and Resources

13. Testing with EF Core

01. Introduction and Overview

02. A Very Quick Testing Overview

03. Understanding What We Mean by [Testing EF Core]

04. Preparing the DbContext

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

06. Exploring Test Results and Performance Considerations

07. Using the InMemory Provider in Place of a Database Provider

08. Refactoring and Testing Some Console App Logic

09. Testing EF Core in an ASP.NET Core App

10. 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. Persisting Enums with EF Core

6. Mapping [Unmappable] Property Types with Value Conversions

7. Applying Bulk Configurations and Conversions

8. Mapping Complex Types and Value Objects

9. Review and Resources

15. Understanding EF Cores Database Connectivity

1. Introduction and Overview

2. Recognizing the Many Database Providers Available for EF Core 6

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. Adding Query Hints to Commands and Other Interceptor Examples

7. Review and Resources

139,000 تومان

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

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

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

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