We are happy to advise you!
+41 44 832 50 80     Contact

Online training in the virtual classroom
E-Learning offers and more

Find out more

Data access with .NET Core (MSDEV05)


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.

Who should attend

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


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


  • 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
Performance Optimization
Tools und Extensions
Work with NoSQL databases
Online Training

Duration 2 days

Price (excl. VAT)
  • Country: CH
    CHF 1,400.-
Classroom Training

Duration 2 days

Price (excl. VAT)
  • Switzerland:
    Country: CH
    CHF 1,400.-
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by Fast Lane.



Time zone Central European Summer Time (CEST)
Online Training Time zone: Central European Summer Time (CEST) Course language: German
Online Training Time zone: Central European Time (CET) Course language: German
Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.