SqlServerCompact EFCore Model Generation

Question

SqlServerCompact EFCore Model Generation

Gianluca Grotto 0

I want to generate a EF Model in a project C# WindowsForm (under .NET6 ) from a SQLServerCompact file. Using Scaffold-DbContext command (see below) I receive an error:

Method ‘Create’ in type ‘EFCore.SqlCe.Scaffolding.Internal.SqlCeDatabaseModelFactory’ from assembly ‘EntityFrameworkCore.SqlServerCompact40, Version=2.2.0.0, Culture=neutral, PublicKeyToken=9af395b34ac99006’ does not have an implementation.

this is the command executed

Scaffold-DbContext -Connection “Data Source= C:\temp\TestModelEFCore\TestModelEFCore\dbsqlcompact\gsdata.sdf;” -Provider EntityFrameworkCore.SqlServerCompact40 -OutputDir dbsqlcompact/Entities -ContextDir DatabaseModel -Context MyContext -UseDatabaseNames -f -Verbose

Any suggestion? thank you Gianluca

Jack J Jun 25,306 Reputation points

2023-04-06T06:10:37.2933333+00:00

@Gianluca Grotto , Welcome to Microsoft Q&A, based on my test, I reproduced your problem. This may be an issue for the nuget package. But based on the description from the package EntityFrameworkCore.SqlServerCompact40 , This package has been deprecated as it is legacy and is no longer maintained. I recommend that you use ef core for sql server to do some alternatives.
Jack J Jun 25,306 Reputation points

2023-04-27T05:22:58.96+00:00

@Gianluca Grotto, is any update? Have you tried my advice to have a test?