EntityFrameworkCore.Jet is an Entity Framework Core provider for Microsoft Jet/ACE databases (supporting the Microsoft Access database file formats MDB and ACCDB).
| EntityFrameworkCore.Jet Version | EntityFrameworkCore Version | .NET (Core) | Notes |
|---|---|---|---|
| 8.0.x | 8.0.x | 8.0+ | Alpha 2 onwards is compatible with EF Core RTM |
| 7.0.x | 7.0.x | 6.0+ | |
| 6.0.x | 6.0.x | 6.0+ |
The major version corresponds to the major version of EF Core (i.e. EFCore.Jet 3.x is compatible with EF Core 3.y).
It runs on Windows operating systems only and can be used with either ODBC or OLE DB together with their respective Access Database driver/provider.
- EntityFrameworkCore.Jet
- EntityFrameworkCore.Jet.Data
- EntityFrameworkCore.Jet.Odbc
- EntityFrameworkCore.Jet.OleDb
All official releases are available on nuget.org.
To use the latest daily builds, add a NuGet.config file to your solution root, add the daily feeds you are interested in and enable prereleases:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<packageSources>
<add key="efcorejet-daily" value="https://www.myget.org/F/cirrusred/api/v3/index.json" />
<add key="efcorejet-daily-debug" value="https://www.myget.org/F/cirrusred-debug/api/v3/index.json" />
<add key="nuget.org" value="https://api.nuget.org/v3/index.json" />
</packageSources>
</configuration>There are two daily build feeds available, one with (optimized) Release configuration builds and one with (unoptimized) Debug configuration builds.
All packages use SourceLink.
In order to simplify writing code for more than just one provider, some Fluent API method names have been made specific to Jet. Examples are:
UseIdentityColumn->UseJetIdentityColumnUseIdentityColumns->UseJetIdentityColumns
More information can be found on our Wiki.
Any questions about how to use EntityFrameworkCore.Jet can be ask on StackOverflow using the jet-ef-provider and entity-framework-core tags.