Search code examples
.net-coresql-server-ceasp.net-core-3.1.net-5

.NET 5 WPF EntityFramework with SQL Compact Edition

Is there a way to use EF with SQL Compact database on the new .NET 5 Windows Framework? I tried it, but I couldn't make it workable.

Is this library supported in .NET 5? EntityFrameworkCore.SqlServerCompact40 (looks empty the package folder)

I cannot access to the optionsBuilder.UseSqlCe(@"Data Source=C:\data\Blogging.sdf"); method.

If it is not supported, can I use EF with CE in .NET Core 3.1?

Solution

  • The library only supports EF Core 2.2. If I get a sponsor I am willing to update.

    You can use SQLCE with raw ADO.NET and .NET 5.

    See more info here; https://erikej.github.io/sqlce/2020/08/17/netcore-sql-compact.html