Use Access And Sql Database Toghether in My Project

Mahdi Elahi 36

Hi,

can i use two database (Access and Sql server) in my project ? how to do it ?
how to use access in .net core with entity framework code first ?

Because i want when the database of the SQL server is changed, the database Access is also changed (For Example write trigger )

AgaveJoe 30,406 Reputation points

2022-07-11T10:57:43.96+00:00
can i use two database (Access and Sql server) in my project ?

Yes. Create two separate DbContexts. You'll need to install a database provider for each database.

https://learn.microsoft.com/en-us/ef/core/providers/?tabs=dotnet-core-cli

how to do it ?

Simply follow follow any code first tutorial for the project type you are creating. You'll end up creating migration for both DbContexts.

https://learn.microsoft.com/en-us/ef/core/get-started/overview/first-app?tabs=netcore-cli
https://learn.microsoft.com/en-us/aspnet/core/tutorials/first-web-api?view=aspnetcore-6.0&tabs=visual-studio

how to use access in .net core with entity framework code first ?

Again, find and install a provider for MS Access and read the documentation.

https://www.nuget.org/packages/EntityFrameworkCore.Jet/
Mahdi Elahi 36 Reputation points

2022-07-14T14:25:38.927+00:00

thank's but i have this error , what's problem ?

i install Microsoft Access Database Engine 2010 Redistributable and Microsoft Access Runtime 2013 but it's not workerd.
i have office 2013 in my system.

Your answer