Update the Catalog .Net Core API

Posts   
 
    
Posts: 1
Joined: 24-Dec-2024
# Posted on: 24-Dec-2024 08:42:46   

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?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39797
Joined: 17-Aug-2003