Hello,
We have developed one .net core 8 Web API "CustomerAPI".
We are using that API as a SAAS service. My JWT token will have the customer ID, and I will get the data based on the customer ID in the token.
Each customer has a separate SQL database, databases are hosted on separate Servers and have different database names as well.
We are writing a middleware to identify the connection string based on the customer id in the token.
The struggle point is how to update the Catalog name in the LLBLGen ORM classes.
When we are generating the models and classes from the database database name is added as a Catalog name in the classes.
So if my customer has a different db name, the API is not working.
Any help with how we can handle it?