Data access with .NET 9 («EFCORE»)

1 Introduction and Overview

2 Create the Model

• Entities
• Data context
• Modeling of the tables
• Fluent API
• Relationships between data

3 Query Database

• Database connection
• Selection of the provider
• Database queries
• Eager vs. Lazy Loading
• Filtering and sorting

4 Storage of Data

• Add, modify, delete
• Concurrency

5 Database Migration

6 Database Model Refinement

• Database index, default values
• Owned Types
• Query Types
• Stored Procedures and Table-valued Functions

7 Further Features

• Table Splitting
• Value Converter
• Global Query Filter
• Data Seeding
• Direct SQL
• Transactions

8 Performance Optimization

9 Tools and Extensions

10 Working with NoSQL databases

This course is aimed at .NET developers who want to efficiently access any database from their web or desktop application.

Knowledge of programming with C# as taught in the CFE course.

COURSE
Modern Web Development with ASP.NET Blazor («ASPBLA»)
1 day
• Basel, Berne, Zürich
CHF
800.–
Learn more
COURSE
ASP.NET Core Advanced («MVC»)
2 days
• Basel, Berne, Virtual Training, Zürich
CHF
1'600.–
Learn more