DB admin meets developer: data access strategy with Entity Framework Core
Details
Synopsis:
ORMs are always developers favourite tools to keep database away (or close?) from their well-designed object oriented code. People are trying to solve impedance mismatch between RDBMS and OOP world for almost two decades, probably even more, and what did we learn so fat, how far did we get to bridge the gap between those two worlds? Entity Framework Core is the latest attempt from Microsoft to solve this problem, a complete rewrite of "old" Entity Framework, with some new rules and concepts that developer or architect needs to know. ORM tools don't hide things, how SQL generated is not black magic, and all relational database good practices and knowledge is still very necessary to write optimal code.
This presentation will cover several areas of implementing data access solution when building .NET app, but also try to get DBAs closer to the developer: what's new in EF Core and difference from EF 6, where it fits in app architecture (unit of work, repository, …), caching of data, migration scripts, different ways of writing queries, how to profile generated SQL code, usage of store procedures and views, inspection of query plans, performance tips&trick, etc.
Since this is SQL usergroup, we will not do too much C# code, I promise. But hopefully will help everybody to understand tools we have to use a little bit better, to make better applications!
Bio:
Hrvoje Hudoletnjak is .NET developer, Microsoft MVP for 6th year now (area of ASP.NET/IIS), lives and works in Dublin. Interested in application architecture, cloud, and all the new fancy buzzwords that look great on CV. Mostly to understand the real benefits, good and bad sides, maybe use few in real app before everything blows up in production, and then do the presentation about it. Like this one.
https://secure.meetupstatic.com/photos/event/e/2/4/600_462723620.jpeg