Transaction across Databases

Posts   
 
    
jerz
User
Posts: 3
Joined: 26-Mar-2008
# Posted on: 18-Sep-2008 15:44:09   

Hi,

We have two databases sitting on the same SQL Server Instance. We have one LLBLGEN project for each database.

Is it possible to add entities/collections, from mutliple projects, to one Transaction object so that deletes in both databases are done in one transaction?

Thanks, Mark

Walaa avatar
Walaa
Support Team
Posts: 14951
Joined: 21-Aug-2005
# Posted on: 18-Sep-2008 16:29:35   

If your system constantly works with these 2 database/catalogs, you could have used one llblgen project and added entities from both catalogs.

Otherwise you might try .NET 2.0: System.Transactions support (distributed transactions).