Microsoft SQL Server Compact Edition

Note

This documentation is for EF Core. For EF6.x, see Entity Framework 6.

This database provider allows Entity Framework Core to be used with SQL Server Compact Edition. The provider is maintained as part of the ErikEJ/EntityFramework.SqlServerCompact GitHub Project.

Note

This provider is not maintained as part of the Entity Framework Core project. When considering a third party provider, be sure to evaluate quality, licensing, support, etc. to ensure they meet your requirements.

Install

To work with SQL Server Compact Edition 4.0, install the EntityFrameworkCore.SqlServerCompact40 NuGet package.


   PM>  Install-Package EntityFrameworkCore.SqlServerCompact40

To work with SQL Server Compact Edition 3.5, install the EntityFrameworkCore.SqlServerCompact35.


   PM>  Install-Package EntityFrameworkCore.SqlServerCompact35

Get Started

See the getting started documentation on the project site

Supported Database Engines

  • SQL Server Compact Edition 3.5

  • SQL Server Compact Edition 4.0

Supported Platforms

  • .NET Framework (4.5.1 onwards)