Having struggled with EF Core adding shadow properties for navigation relationships, I finally found out what it’s doing and (more importantly) how to fix it.
Tag: <span>EF Core</span>
I wanted to speed up the performance of a Telerik Blazor grid. This post documents an extension method I wrote to enable this using EF Core. This was at least as fast (if not faster) than the previous method i wrote based on Dapper, and has some significant extra features
Last month, I explained how we had achieved a significant performance improvement by using Dapper to pull the data from the database, rather than using EF Core.
Whilst showing this to a colleague, he reminded me that EF Core has a FromSqlRaw method that does pretty much the same thing. Assuming that EF Core would be slower than Dapper, I didn’t give it much thought at the time. However, being a compulsive tinkerer, I decided to take a closer look.
This post explains my findings, and what I did with them
Being fairly new with EF Core, I am still discovering solutions to problems that I solved long ago with database-first development.
Today I found out how to add a non-nullable foreign key reference to a new table.
Leave a Comment