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.

This text was automatically translated. Please click here to read the original German version.

Who should attend

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

Prerequisites

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

Prices & Delivery methods

Online Training

Duration 2 days

Price (excl. tax)
  • 1,190.— €

Courseware language: German

Classroom Training

Duration 2 days

Price (excl. tax)
  • Germany: 1,190.— €
  • Switzerland: CHF 1,490.—

Courseware language: German

Schedule

FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

German

Time zone: Central European Summer Time (CEST)   ±1 hour

Online Training Show training days 1 day This is a FLEX course. Time zone: Central European Time (CET)
Online Training Show training days 1 day This is a FLEX course. Time zone: Central European Time (CET)
Online Training Show training days 1 day This is a FLEX course. Time zone: Central European Time (CET)
Online Training Show training days 1 day This is a FLEX course. Time zone: Central European Summer Time (CEST)
Online Training Show training days 1 day This is a FLEX course. Time zone: Central European Summer Time (CEST)
Online Training Show training days 1 day This is a FLEX course. Time zone: Central European Summer Time (CEST)
Online Training Show training days 1 day This is a FLEX course. Time zone: Central European Summer Time (CEST)
Online Training Show training days 1 day This is a FLEX course. Time zone: Central European Summer Time (CEST)
+ show all dates
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

Switzerland

Basel Show training days 1 day This is a FLEX course in German language. Time zone: Central European Time (CET) Course language: German
Bern Show training days 1 day This is a FLEX course in German language. Time zone: Central European Time (CET) Course language: German
Zurich Show training days 1 day This is a FLEX course in German language. Time zone: Central European Time (CET) Course language: German
Basel Show training days 1 day This is a FLEX course in German language. Time zone: Central European Summer Time (CEST) Course language: German
Bern Show training days 1 day This is a FLEX course in German language. Time zone: Central European Summer Time (CEST) Course language: German
Zurich Show training days 1 day This is a FLEX course in German language. Time zone: Central European Summer Time (CEST) Course language: German
Basel Show training days 1 day This is a FLEX course in German language. Time zone: Central European Summer Time (CEST) Course language: German
Bern Show training days 1 day This is a FLEX course in German language. Time zone: Central European Summer Time (CEST) Course language: German
+ show all dates

If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.