Creation of database applications using ORM (Entity Framework)

• You get an overall overview
• You will learn to use LINQ and querying relational databases
• You will learn how to project changes to a data source using Savechanges
• You will learn to use Migrations

• The course assumes knowledge and experience with C# programming at the level of the GOC2125 course
• The course can be taken without prior knowledge of c# and the .Net platform, but in that case a very good programming knowledge of other platforms and languages such as Java or C++ is required.

• Expert interpretation with practical examples, exercises on computers.

• Printed presentations of the discussed material.

Introductory overview

• History
• NuGet packages
• Model

Mapping

• Entities
• Property
• Keys, alternative keys
• Generated ID
• Association
• Backing fields
• Owned types
• Model Level Filters
• Table Splitting, Table Sharing
• Heredity, TPT, TPH
• Value Converters, Value Comparators
• Keyless entities
• ctor parameters
• Query tags
• Shadow properties
• Shared entities, property bags
• Flexible mapping
• Seeding

Interviewees

• LINQ, parameters
• pure SQL
• function
• query compilation
• Include, Explicit loading, Filtered Include
• Lazy Loading
• Split queries
• tracking, no tracking queries

SaveChanges

• validation
• batching
• ID generation
• transactions
• ChangeTracker
• concurrency

Migration

• work with migrations
• touch ef
• IMigrator
• script, idempotent, transaction

Other platforms

• Works on other platforms
• Working with "other" DBs

Previous courses

Programming with C# Language I [GOC2124]

Programming with C# Language II [GOC2125]

Core Data Access with Microsoft Visual Studio [GOC311]

Next courses

Parallel, Asynchronous and Multithreaded Applications [GOC407]

Related courses

ASP.NET II [ASPNET_ADV]

ASP.NET I [ASPNET_INTRO]

ASP.NET - Application development in Blazor [ASPNET_BLAZOR]

.NET MAUI [DOTNET_MAUI]

Development of Windows applications using WPF using the MVVM pattern [DOTNET_WPF2]

Development of automated tests in Visual Studio [DOTNET_TEST]

Developing Windows Applications with WPF [DOTNET_WPF]

Implementing a REST API using ASP.NET Web API [ASPNET_WEBAPI]