How to use Dotnet ef tool to create access tables class

Question

Now,I had use the assemables with EntityframworkCore.Jet and EntityframeworkCore.Jet.Oledb are not be create the access tables classes by entityframeworkCore
use DotNet ef tool
the command is
dotnet ef dbcontext scaffold "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=123.accdb,OleDbFactory.Instance" DotNetFramworkCore.Jet --project windowsformsapp1

dotnet ef dbcontext scaffold "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=123.accdb,OleDbFactory.Instance" EntityframeworkCore.Jet.Oledb --project windowsformsapp1

dotnet ef dbcontext scaffold "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=123.accdb,OleDbFactory.Instance" System.Data.OleDB --project windowsformsapp1

do I build the entityframworkCore command ?

Answer 1

You can try my tool to scaffold your Access database which I wrote a while back for fun.

From the screenshot below it generated

Scaffold-DbContext "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\OED\Dotnetland\ScaffoldDbContextHelper\AccessScaffoldDbContextHelper\bin\Debug\NorthWind.accdb" -Provider EntityFrameworkCore.Jet -OutputDir Models  -Context NorthContext  -v -f  -project Microsoft.Access.Data -startupproject Microsoft.Access.Data -ContextDir Contexts -t "Categories","Customers","CustomersContactTitle","Employees","Orders","Products","Suppliers","SuppliersContactTitle"