Thursday
Room 3
10:20 - 11:20
(UTC+10)
Talk (60 min)
Entity Framework (Core) Unchained: Getting the Best Performance from Your ORM
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.
Dan Mallott
Dan Mallott is the Team Lead for the Platform Team at Visma e-conomic in Copenhagen, Denmark. His passion is for distributed architecture, designing and building high performing service layers from the API down to the database.
Recently, Dan has been focused on leading the Platform Team in improving the cross-cutting concerns in the e-conomic application, including improving security, improving messaging performance, and managing the migration to .NET 6.0.
Previously, Dan was a Senior Principal for West Monroe, based in Chicago, IL, USA. While at West Monroe, Dan's projects included designing high performing architectures for a variety of clients, as well as developing APIs and UIs for healthcare, insurance, and financial services clients. Along the way, Dan worked with .NET Framework, .NET Core, Java/Spring Boot, React, and Angular. He also gained experience with a number of database technologies, including DataStax, Cassandra, Microsoft SQL Server, Oracle, and PostgreSQL. Prior to joining West Monroe, Dan worked for a number of companies, focusing on .NET and Microsoft SQL Server development, including experience as a DBA.
Past speaking engagements have included PASS Summit, NDC London, NDC Melbourne, NDC Sydney, KCDC, Code PaLOUsa, and numerous SQL Saturdays throughout the US. Dan enjoys speaking at both large and small conferences, and values the interactions he gets with attendees and other speakers.
In his spare time, he can be found writing his own software instead of using package solutions or on the ice as an ice hockey player and referee.