Hi,

We have developed a web application. we are using LBLGEN 2.0 for DAL and accessing SQL server 2005 right now. Now our requirement is to support multiple SQL servers database.

Please guide me, how to proceed further?

Hi,

I guess you want to have multiple databases to support multiple instances of the application for different companies/users ?!

So you have 1 set of code with multiple databases for each client? Or do you have 1 applicaiton which needs to access multiple databases, in that case you could include multiple databases in your LLBLGen project (but I presume it's the first scenario)

Are you using Adapter or SelfServicing?

Take a look at:

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=5288

and

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=5209

Cheers, Gab

One application which needs to access multiple databases based on user's selection. Right now we generated DAL in SelfServicing mode.

it may be alot of work, but I would recommend migrating to the adapter model. this model provides the functionality required to access multiple databases.

I think it's possible with SS, but it's a hack. SS is designed for single db access. I haven't used SS so I can't say for sure.

As said it's a "hack" or at least a "not so nice" solution. One of the problems is the possible performance issues, for example (this I cite, and don't know from experience) the connection pooling isn't (at all) used in this scenario.

I've worked with it without problem, but not in large scale applications or large amounts of databases.

Cheers, Gab

If your multiple databases resides in multiple servers, and thus they all have the same catalog/database name. Then using the SelfServicing model you can just switch the server name in the connection string.

But if the multiple databases resides in the same database server/instance but using different catalog names, then it's better that you use the Adapter model to switch between different catalogs at runtime.

Is there any more info about possible performance issues?

Thanks, Gab

Gab wrote:

Is there any more info about possible performance issues?

What do you mean?

Not to worry... is explained enough in the quoted threads.

Thanks