Course Overview
You need to be able to access your data in databases efficiently and reliably from your application? This training shows you the way.
Moyens d'évaluation :
- Quiz pré-formation de vérification des connaissances (si applicable)
- Évaluations formatives pendant la formation, à travers les travaux pratiques réalisés sur les labs à l’issue de chaque module, QCM, mises en situation…
- Complétion par chaque participant d’un questionnaire et/ou questionnaire de positionnement en amont et à l’issue de la formation pour validation de l’acquisition des compétences
Who should attend
This course is for .NET developers who want to efficiently access any database from their web or desktop application.
Prerequisites
Master Class: C# Advanced (MSDEV03), optionally recommended Master Class: .Net 5 Technologies (MSDEV04)
Course Objectives
- Using EF Core to efficiently implement your data access layer
- Know numerous tools to be able to work productively.
Course Content
Introduction and overview
Create the model
- Entities
- Data context
- Modeling of the tables
- API Fluent
- Relationships between data
Query
database
- Database connection
- Provider selection
- Database queries
- Eager vs. Lazy Loading
- Filtering and sorting
Save data
- Add, modify and delete
- concurrency
Database Migration
Refine database model
- Database index, default values
- Owned Types
- Query Types
- Stored Procedures und Table-valued Functions
Other features
- Table Splitting
- Value Converter
- Global Query Filter
- Data Seeding
- Direct SQL
- Transactions
Allemand
Suisse
Moyens Pédagogiques :