Entity Framework Core - Knowledge Base (KB)

dotnet ef migration list not finding migrations in Migration folder

I was following ...this tutorial... (On linux and converted to F#) Migrations were created successfully (3 files in the ...Migrations... directory.) But ...dotnet ef database update... says everything is up to date and ...dotnet ef migrations list... say...

Calling EF Core HasIndex from F#

I'm trying to rewrite a C# EF Core example (similar to ...the one in the docs...) into F#. I have a problem with ...HasIndex.... In C#, the call is ...HasIndex(b => b.Isbn)..., to create an index on the Isbn column:...public class SampleContext : DbContex...

Entity Framework Core : Apply Conversion to all properties of type Option<T> in F#

I'm using Entity Framework Core 2.1 in F#.... I want to setup a generic type conversion for ...Option... types so that EF knows how to handle them. ...I found ...this... very helpful post that shows how to setup a generic convertor for ...Option... type...

EF Core replace all related child entities

I am implementing the repository for a RESTful microservice using EF Core 3.1 and MS SQL Server, and I'm experiencing some strange behavior when doing a PUT that updates data backed by a navigation property in the data model. The purpose of the microserv...

Entity Framework Core GroupBy Date

In C# you can group by ....Date...:...db.History.GroupBy(x => x.Timestamp.Date) .Select(g => new { key = g.Key, aggregate = g.Count() }) ...However, the equivalent F# does not work:...db.History.GroupBy(fun x -> x.Timestamp.Date) .Sele...

Interpolated strings in F#

I am trying to use the Entity Framework Core interpolated SQL query function in F# which requires a ...FormattableString.... However to my surprise it doesn't function as I cannot find a way to convert a regular F# string to that type. I figured just doin...