This may be more of a question I can post on the dotnet forums but I wanted to asked for the expert opinion from the Appeon community first.
Lets say I create a web api from my data windows using the C# generator. I want to have a database for each tenant/client. I need to be able to call the right database based on a value passed to the web api (could be a key, id, connString, etc). How would I dynamically select the right database based on that value using, for example, an ODBC connection to a SQL Anywhere database?
Our need: We need to be able to call the web api with the data + the ID for the intended database at runtime.
Question: How would we dynamically select the right database at runtime?