Multiple databases questions

Posts   
 
    
dravidian
User
Posts: 10
Joined: 31-Dec-2007
# Posted on: 01-Jan-2008 00:52:00   

Happy New Year everyone!

I'm trying out LLBLGEN Pro 2.5 Demo version right now. It looks really great so far! I have a bunch of questions I hope people can help me with.

I'm testing this out on a site that will contain two databases. One database for user/profile/logging etc, and one for 'site specific' data.

  1. Do I need create 2 different projects in LLBLGEN for each database?
  2. I made the mistake of starting out by putting my user tables in the same database and creating one project for all my entities. Will I need to start from scratch with my codegeneration?
  3. Where can I find information on what happens to the generated code when I change database structure and need to regenerate the code?

I'm using the Adapter method to access data.

Thanks

Dravidian

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 01-Jan-2008 04:40:44   

dravidian wrote:

  1. Do I need create 2 different projects in LLBLGEN for each database?

You can make a single project to target two (or more) databases, depending upon you needs. (if the catalogs are in the same SqlServer server).

dravidian wrote:

  1. I made the mistake of starting out by putting my user tables in the same database and creating one project for all my entities. Will I need to start from scratch with my codegeneration?

I'm afraid you should start again. But maybe your business specific code still works with a little refactoring.

dravidian wrote:

  1. Where can I find information on what happens to the generated code when I change database structure and need to regenerate the code?

LLBLGenPro Help - Using the designer - Refreshing the catalog schemas. LLBLGenPro Help - Using the designer - Generating code.

Please let us know if we can help you further.

Happy New Year!

David Elizondo | LLBLGen Support Team
dravidian
User
Posts: 10
Joined: 31-Dec-2007
# Posted on: 03-Jan-2008 05:11:45   

Thanks Daelmo.

I also found the references to 'DatabaseAdapterFactory' in other posts - and I'm now using that to handle the connectivity to different databases.