Master Class: Data access with .NET Core (MSDEV05)

 

Course Overview

Do 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.

Prerequisites

!, with the option to attend ! recommended

Course Objectives

  • Be able to use EF Core to efficiently implement your data access layer
  • Become familiar with 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
Modality: L

Duration 2 days

Price
  • Eastern Europe: 1,190.— €
Classroom Training
Modality: C

Duration 2 days

Price
  • Eastern Europe: 1,190.— €

Schedule

English

Time zone: Central European Time (CET)

Online Training This is a FLEX course. Time zone: Central European Summer Time (CEST)
Online Training This is a FLEX course. Time zone: Central European Summer Time (CEST)
Online Training This is a FLEX course. Time zone: Central European Summer Time (CEST)
Online Training This is a FLEX course. Time zone: Central European Summer Time (CEST)
Online Training This is a FLEX course. Time zone: Central European Time (CET)

6 hours difference

Online Training Time zone: Eastern Standard Time (EST)

7 hours difference

Online Training Time zone: Eastern Standard Time (EST)
Online Training Time zone: Eastern Standard Time (EST)
Online Training Time zone: Eastern Standard Time (EST)
Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO).

Europe

Germany

Düsseldorf Enroll
Hamburg Enroll
Berlin Enroll
Stuttgart Enroll
Hamburg Enroll

Switzerland

Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO).