Multiple Catalogs, confirmation

Posts   
 
    
Jackk100
User
Posts: 48
Joined: 11-Jan-2005
# Posted on: 12-Oct-2005 01:30:44   

Hi,

I'm using v1.0.2004.1, Adapter. I want to be able to use two different databases (containing unrelated data) for the same web site. I'm not sure the best way to go about it. I've read forum threads, but am still unclear.

IE have two databases, totally unrelated, but want to access them via LLBLGen in the same web project. IE, db's are:

Tickets Products

In addition, on different environments (dev, test, staging, production) the databases might have different names:

TicketsDev ProductsTest etc....

so I need to be able to do something like this in the web.config:

<add key="CatalogNameUsageSetting" value="1"/>
<add key="CatalogNameToUse" value="TicketsDev" />

Does v1.0.2004.2 natively handle this kind of thing? If not, any advice?

I'm guessing that I need to generate a project for each database and include those in my solution, then do something in web.config or app.config's to set the connection string and map the catalog names on each environment. ???

Thanks, Jack

Drewes
User
Posts: 67
Joined: 18-Aug-2003
# Posted on: 12-Oct-2005 02:51:44   

I n the user guide look in the best practise section on how to pass a different connection string at runtime, that should allow you to do what you want to accomplish.