Provider MS Office Access
Редактировал(а) Alexandr Fokin 2023/12/02 17:22
EntityFrameworkCore.Jet
https://www.nuget.org/packages/EntityFrameworkCore.Jet/3.1.1
https://github.com/bubibubi/EntityFrameworkCore.Jet
https://github.com/bubibubi/EntityFrameworkCore.Jet/wiki
Рабочий Setup:
| EntityFrameworkCore.Jet | 3.1.1 | |
| EntityFrameworkCore.Jet.OleDb | 3.1.1 | |
| Microsoft.EntityFrameworkCore.Tools | 3.1.22 | |
| System.Data.Odbc | 5.0.0 | |
| System.Data.OleDb | 5.0.0 | |
| Microsoft Access Database Engine 2010 Redistributable | 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine |
// Строка подключения
@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\myFolder\myAccessFile.accdb;"
// Генерация контекста
Scaffold-DbContext -Connection "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\myFolder\myAccessFile.accdb;" -Provider EntityFrameworkCore.Jet
@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\myFolder\myAccessFile.accdb;"
// Генерация контекста
Scaffold-DbContext -Connection "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\myFolder\myAccessFile.accdb;" -Provider EntityFrameworkCore.Jet