course
Entity Framework: Data Access in .NET
Develop Data Access Applications using Microsoft Visual Studio and Entity framework
Description
In this training you will learn how to read data from a relational database using the Entity Framework, how to write it back after you have adjusted it. You get to know the Entity Framework thoroughly and among others you will learn to work with migrations, transactions and concurrency.
Learning Goals
 Understand the concept of an ORM | Understand  |
| Apply Code First | Apply  |
| Apply Querying an entity data model. | Apply |
| Understand Loading entities | Understand |
| Apply migrations | Apply |
| Understand using CRUD operations in Entity Framework Core | Understand |
For the above learning goals we use Bloom's Taxonomy
Prior Knowledge
- Basic knowledge of the Microsoft Visual Studio development environment.
- A basic understanding of Microsoft .NET Core
- Knowledge of C#.
- A good understanding of relational database concepts and the SQL language.
Subjects
Architecture and Data Access Technologies
- Mismatch between OO and Relational Model
- ORM
Entities
- Entity types
- Entity properties
- Keys
- Fluent API vs. Data annotations
- Inheritance solutions:
- Table per Hierarchy
- Table per Type
- Table per Concrete Type
Relationships
- One to many
- One to one
- Many to many
Querying Entity Data
- LINQ
- IQueryable
- Loading related data:
- Eager loading
- Explicit loading
- Lazy loading
- Pagination
Creating, Updating, and Deleting Entity Data
- Add a new item
- Update an item
- Delete an item
- Saving related data
- Concurrency conflicts
- Transactions
SQL Queries
- FromSQL, SQLQuery, ExecuteSQL
- Database functions
- Query filters
Migrations
- Add Migration
- Update the database
- Seeding
ChangeTracker
- DBContext
- Entries
- Explicit Tracking
Logging
Testing
Improving Performance
- Benchmarking
- Efficient Querying
- Asynchronous data modifications
Read more
Schedule
| Start date | Duration | Location | |
|---|---|---|---|
April 7, 2026April 8, 2026April 9, 2026 | 3 days | Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information | Sign up |
May 11, 2026May 12, 2026May 13, 2026 | 3 days | Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information | Sign up |
July 13, 2026July 14, 2026July 15, 2026 | 3 days | Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information | Sign up |
All courses can also be conducted within your organization as customized or incompany training.
Our training advisors are happy to help you provide personal advice or find Incompany training within your organization.
Trainers
Prior knowledge courses
"Very pleasant teacher, gave a very good interpretation of the course in their own way. It was nice to follow the course like that."Marieke
-
Hoge waardering
-
Praktijkgerichte trainingen
-
Gecertificeerde trainers
-
Eigen docenten