I have multiple databases that need to be connected to a single website. Essentially, I need to connect this data to a website where users can add, delete, and update certain data. Both the databases and website already exist.
Requirements:
- Connect multiple databases to one existing website
- Allow certain users, certain access, to add, delete, and update data in the databases via the website.
What I have tried:
I started to create a Web API in Visual Studio ASP.NET and I had already connected one database to it. However, I am confused on how to connect that to an existing website and I realized connecting each database one by one would be time consuming.