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. The training will mainly use Entity Framework Core 6.0.

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]

Subjects

• Mismatch between OO and Relational Model
• ORM
• Inheritance solutions:
  • Table per Hierarchy
  • Table per Type
  • Table per Concrete Type
• Concurrency conflicts
• Indexes

• Fundamentals of Code First
• Workflow
• Conventions
• Data annotations
• Fluent API
• ConnectionString
• Data Seeding

• LINQ
• IQueryable
• Logging
• Reverse Engineering and scaffolding

• Loading related data:
  • Eager loading
  • Explicit loading
  • Lazy loading
• Relationships

• Entity Framework Tools
• Enabling migrations
• InitialCreate
• Performing migrations
• Update the database

• Add a new item
• Update an item
• Delete an item
• Use Stored Procedures
• Filter queries

• DBContext
• ChangeTracker
• Asynchronous querying and saving
• Inject Services

• Concurrency problems
• Pessimistic vs. optimistic concurrency
• Resolving conflicts
• Transactional support
• Managing transactions

• Testing concepts
• Initialize
• In memory

• What is NoSQL?
• BASE
• Characteristics
• CosmosDB
  • APIs
  • Schema free

• Asynchronous data modifications
• Change tracking
• Restriction on client evaluation
• DBFunctions

• Table splitting
• Database scalar function mapping
• Keyless entity type
• Temporal tables