Hello
Using .NET Core, SQL Server 2019.
I have a SQL server with multiple databases for different customers. the database names example are
-ABC
-XYZ
-ABR
My product is a .NET Core Angular application. I want to have one application running but be able to connect to each individual database based on some pattern or file.
For example
www.product.com/ABC > Points to ABC db
www.product.com/XYZ > Points to XYZ db
www.product.com/ABR > Points to ABR db
So the connection string has to be dynamic for each call during run-time. V5.6 documentation suggests setting a connection string during startup.
Can you please help me with the exact setup and steps I have to take to accomplish this.
Thanks