Course
Data access with .NET 9 («EFCORE»)
Entity Framework Core is a completely new development of the well-known Entity Framework – open-source and platform-independent. The new OR mapper is more powerful and has numerous new features compared to the previous version.
Duration
2 days
Price
1'600.–
Course facts
- Using EF Core to efficiently implement your data access layer
- Knowing a variety of tools in order to work productively
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.