Cross DB transactions?

Posts   
 
    
ianvink
User
Posts: 394
Joined: 15-Dec-2006
# Posted on: 05-Jul-2007 13:57:15   

Version 2, C#, newest version, SelfServing

I have 2 databases on the same SQL Server 2000.

Each database has an LLBL project.

I have a business object that has some entities in each database.

When I save the business object, I want it to save in one over all transaction.

Is that possible? How?

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 05-Jul-2007 15:09:07   

Why don't you have one LLBLGen Pro that contains entities from both databases?

ianvink
User
Posts: 394
Joined: 15-Dec-2006
# Posted on: 05-Jul-2007 16:33:23   

You can do that?!?

How?

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 06-Jul-2007 10:32:34   

Yes you can add more than one catalog to the same LLBLGen Pro project. From the Designer -> Refresh All Catalogs, and add the new catalog to the list of previously added catalogs, by selecting it from the list of catalogs.

ianvink
User
Posts: 394
Joined: 15-Dec-2006
# Posted on: 06-Jul-2007 13:08:10   

Fantastic, I thought that dialog was to add only 1 DB. That we can access a variety really opens up the possibilities for us.

Thanks!