Search

Showing posts tagged EF Core.

30th April 2026

MissingMethodException when adding a migration in EF Core

I have a Blazor app that I've been developing for a while, and wanted to add a migration. Done this plenty of times before, so didn't expect anything unusual.

Instead of the usual success, I saw the following exception... The running command stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: System.Management.Automation.RemoteException.

No, I didn't know what that meant either! Now I do, and if you read my ramblings, you will as well.

24th July 2025

Accessing user claims via a navigation property in EF Core

Having struggled for a while trying to load claims when pulling users from the database, I rediscovered really easy way to do this

6th January 2025

Microsoft.EntityFrameworkCore.Model.Validation[10625] The foreign key property 'ShortlistItem.ShortlistId1' was created in shadow state because a conflicting property with the simple name 'ShortlistId' exists in the entity type

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.

9th October 2024

Using the EF Core FromSqlRaw method in a Telerik Blazor grid

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

8th October 2024

Hmm, maybe EF Core isn't so bad after all!

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

17th July 2019

Adding a non-nullable foreign key reference

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.