Résumé du cours
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
A qui s'adresse cette formation
This course is for .NET developers who want to efficiently access any database from their web or desktop application.
Pré-requis
Master Class: C# Advanced (MSDEV03), optionally recommended Master Class: .Net 5 Technologies (MSDEV04)
Objectifs
- Using EF Core to efficiently implement your data access layer
- Know numerous tools to be able to work productively.
Contenu
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 :