Marco Minerva Microsoft MVP Windows Development Intel Software

Marco Minerva Microsoft MVP Windows Development Intel Software Innovator https: //about. me/marcominerva #sqlsat Riccardo Cappello Microsoft MVP Microsoft Azure Intel Software Innovator https: //about. me/rcappello

. NET Core 3. 0

. NET Core 3 2 WEB CLOUD . NETrequirements Core 3 expands supported. NET Core is perfectly suited for the workloads to include Windows of cloud-native, cross-platform workloads Io. T DESKTOP Desktop, Io. T & AI . NETCORE 3. NET LIBRARIES INFRASTRUCTURE AI

https: //marketplace. visualstudio. com/items? item. Name=B rian. Lagunas. Convert. Project. To. NETCore 3

https: //dotnet. microsoft. com/download/dotnet-core/3. 0

Demo

Data Access Methodologies

System. Data. Sql. Client

Classic ADO. NET approach

Entity Framework Core

Only in EF 6 • • • Stored procedure mapping for CUD Many-to-many TPT, TPC inheritance Entity splitting Simple logging API Change tracking proxies Interception extensibility Database-agnostic SQL dialect Visual designer Common features • • • • Spatial data* Seed data Lazy loading Group. By translation Any type from raw SQL System. Transactions Change tracking events Compiled queries Complex/owned types Table splitting Eager loading Connection resiliency TPH inheritance Only in EF Core • • • • • • Cosmos DB provider* Collections of owned entities* Query tags* Reverse engineering of database views* Eager loading for derived types Non-default constructors Rich value conversions Query types (no keys) Cross-platform &. NET Standard Global query filters Db. Context pooling Simple function mapping Rich diagnostics and logging Alternate keys Field mapping Shadow properties More readable SQL Client key generation Batching of statements Mixed query evaluation Disconnected graph API DI and service replacement LINQ composition over raw SQL In-memory provider (for testing)

2018 • Entity Framework Core 2. 2 • Cosmos DB provider (preview) • Spatial extensions for SQL Server and SQLite • Reverse engineering of database views • Collection of owned entities • Query tags 2019 • Entity Framework Core 3. 0 • Improved LINQ implementation • Aggregate behaviors • C# 8 support: • Nullable reference types • Standard IAsync. Enumerable<T> interface • Public code first conventions • Better support for Views • Property bag entities (for many-to-many relationships) • Ignore parts of the model for Migrations • Entity Framework 6. 3 running on. NET Core 3. 0

Dapper

Data Access Architecture

Presentation Layer Business Layer Data Access Layer Sql. Client Entity Framework Dapper …

Presentation Layer Business Layer Data Access Layer

Demo

https: //dotnet. microsoft. com https: //github. com/dotnet/wpf https: //github. com/dotnet/winforms https: //docs. microsoft. com/en-us/ef/core https: //github. com/Stack. Exchange/Dapper https: //www. telerik. com/products/wpf/overview. aspx https: //github. com/marcominerva/Sql. Sat 829

Marco Minerva - @marcominerva Microsoft MVP – Windows Development http: //about. me/marcominerva Riccardo Cappello - @rcappello Microsoft MVP – Microsoft Azure http: //about. me/rcappello Dot. Net. Toscana Dotnettoscana. org @dotnettoscana