Entity Framework

If you are running Microsoft SQL Server locally in Docker, when you connect to it you might get an error - The remote certificate was rejected by the provided RemoteCertificateValidationCallback. Here is how to fix it.

Using CockroachDb with Entity Framework is easy, here is a simple post showing how.

After you save an entity, you may want to send out a notification so other parts of your application can react to the change. This post shows how to do that with MediatR and Entity Framework Core.

Find/FindAsync is a popular way to retrieve a single entity using its primary key with Entity Framework, but by default Entity Framework tracks that entity for changes. This post shows how to turn off tracking for Find/FindAsync.

Here is a way to access objects just after they are saved by Entity Framework and have had a primary key assigned to them.

I left out version number in a package reference and got the exception - Exception has occurred: CLR/System.MissingMethodException An exception of type ‘System.MissingMethodException’ occurred in System.Collections.Concurrent.dll but was not handled in user code: ‘Method not found: ‘System.IServiceProvider.

I have been a fan of Entity Framework for many years, and have relied on using the context within the Configure(..) method in Startup.cs, but that is not available when using top-level statements. This post shows how to use the context within Program.cs.

There are times when firing off the same query in parallel to two or more data stores is a good choice, but normally hitting one, waiting for the response, and only hitting the second if necessary is a better approach. Here I’ll show how to query Redis, and if the key is missing, query MS SQL.

There are times when firing off the same query in parallel to two or more data stores is a good choice, keeping the first response, and canceling the other requests. Here I show how a achieve that even if the Task<> types are different.

Want to see how easy it is to use a SQL Server Docker container with Entity Framework for .NET 6?