The migrations generate F# code in a C# project

[lucasteles]

I'm working in a project that mix F# and C#, today the DbContext is in the C# part,
I would like to use some of the features of this package, but the generated migration is a mix of C# and F# (which does not compile)

    public partial class escola : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name = "Escolas"
                ,columns = (fun table -> 
                {|
                    Id =
                        table.Column<Guid>(
                            nullable = false
                            ,``type`` = "uuid"
                        )
                    Nome =
                        table.Column<string>(
                            nullable = true
                            ,``type`` = "character varying(200)"
                            , maxLength = Nullable(200))
                    IdUsuarioAdmin =
                        table.Column<string>(
                            nullable = true
                            ,``type`` = "text"
                        )
                |})
                ,constraints =
                    (fun table -> 
                        table.PrimaryKey("PK_Escolas", (fun x -> (x.Id) :> obj)) |> ignore
                        table.ForeignKey(
                            name = "FK_Escolas_AspNetUsers_IdUsuarioAdmin",
                            column = (fun x -> (x.IdUsuarioAdmin) :> obj)
                            ,principalTable = "AspNetUsers"
                            ,principalColumn = "Id"
                            ,onDelete = ReferentialAction.Restrict
                            ) |> ignore

                    ) 
            ) |> ignore

            migrationBuilder.CreateIndex(
                name = "IX_Escolas_IdUsuarioAdmin"
                ,table = "Escolas"
                ,column = "IdUsuarioAdmin"
                ) |> ignore


        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name = "Escolas"
                ) |> ignore


        }
    }
}

The is any way to workaround this?
Should this package discover is the project is a F# project?
Or should we have a configuration for that?

[simon-reynolds]

Hi @lucasteles

Currently the EntityFrameworkCore.FSharp.props file should only register EFCoreFSharpServices if the project it's installed into is an F# project.

A possible workaround would be to register your own implementation of IDesignTimeServices that restores the default c# generators
Looking at EFCoreFSharpServices.fs, simply replacing every instance of FSharp with CSharp and removing ScaffoldOptions and FSharpMigrationsGeneratorDependencies should do the job

[bricelam]

Hmm... this bug might belong in dotnet/efcore. I wouldn't be surprised if I accidentally used the startup project's language instead of the target/migrations project's language.