Entity Framework (Core) Unchained: Getting the Best Performance from Your ORM - Dan Mallott

Entity Framework makes data access in .NET applications as easy as defining some classes, adding a connection string, and writing some LINQ statements. But listen to developers and database administrators and you will find that taking the naive approach leads to poor performance, bloated databases, elaborate workarounds, and general dissatisfaction with the technology.

It doesn't have to be this way! Behind the simple facade, Entity Framework gives us multiple options for tuning our data access and improving performance. In this talk, you will learn configuration options and access patterns that can help improve performance. You will also learn what features in Entity Framework to use judiciously or avoid entirely. Next, you will learn some strategies for structuring your database in ways that both improve performance and simplify your application code. Lastly, you will learn some tipping points about when you should discard Entity Framework entirely.

Check out more of our featured speakers and talks at

[marna_li]

A very informative talk about stuff we really should care about when using EF Core! And + Dan is a good speaker.

[alexisfibonacci]

EF Core now has escape hatches that can do what Dapper does (especially with raw queries). Also mapping to DTO projections is now on par with Dapper... Let us see what more performance gimmicks they can come up with in subsequent versions.

[KibbleWhite]

According to this, I've done absolutely everything 100% wrong lol

[lmddolat]

Thank you very much, I got much useful information's, you just opened my eyes to things I should care about it before start

[ErnestoMorin]

Some good points. Would be nice to know best approach on switching from code first to database first.

[khealer]

39:45 You can do SqlBulkCopy into a Temporary Table if you want to avoid the User Table Type.

[thowheedh]

Please share the link to slides presented in the video in description

[jenkins]

This is all well and good, but how would you combine EF with something like DDD? In this talk you introduce a bunch of models that aren't really aggregate roots, if you have performance issues loading an aggregate like the User w/ Posts example, then it probably means the design is wrong, i.e. does a User aggregate REALLY need a collection of posts?

[lyndonarreza]

Using migration in Django is not painful compare to add-migration in entity framework.hope they will fix that issue

[chashdeveloper]

Creating joins using ef core is a terrible idea. the lambda syntax can get real messy. is there anyway we can ensure column name consistency if we run raw sql query using ef?