Best way to connect an existing Umbraco 10 project to another DB
Hi community :)
I have a situation where I want my existing Umbraco (v10) project to communicate with other databases. Currently, my Umbraco project is using a SQL DB. I would like to add a couple more SQL DBs (will only be using them for a special kind of authentication and other stuff..).
Now, I would like some ideas on how best to connect and communicate to these DBs? Thanks!
I ended up going the route of creating multiple schemas and using Entity Framework Core to perform the DB-first approach to scaffold my model classes and multiple DB contexts.
Best way to connect an existing Umbraco 10 project to another DB
Hi community :)
I have a situation where I want my existing Umbraco (v10) project to communicate with other databases. Currently, my Umbraco project is using a SQL DB. I would like to add a couple more SQL DBs (will only be using them for a special kind of authentication and other stuff..).
Now, I would like some ideas on how best to connect and communicate to these DBs? Thanks!
It sounds like you need to create your own repository and service. You could use Entity Framework for example.
I ended up going the route of creating multiple schemas and using Entity Framework Core to perform the DB-first approach to scaffold my model classes and multiple DB contexts.
is working on a reply...