NHibernate with multiple databases and transactions

Question

We are having a few problems understanding how best to use NHibernate. We typically have a relatively large number of quite small (in terms of number of tables) SQL Server databases rather than one database with a lot of objects.

We are looking at various options for handling multiple session factories and probably have this under control. However we are not sure how we would wrap all calls in a single transaction. Using hand-rolled data access you would just wrap it all in a TransactionScope but we are a little reluctant to do this with NHibernate as it seems to like to handle all its own Transactions.

Using multiple databases with shared transactions seems like the sort of thing lots of people would want to do with NHibernate.

Are we just barking up the wrong tree entirely?

You might want to look into the source of the NHibernate Sharding project to get some ideas because it sounds like you have a sharded database. — Chris Marisic
– Chris Marisic, Commented Jun 11, 2010 at 16:05

Diego Mijelshon · Accepted Answer · 2010-06-11 17:01:56Z

3

You can safely use TransactionScope. But you have to open NHibernate transactions too.

Example:

using (var ts = new TransactionScope())
using (var session1 = sessionFactory1.OpenSession())
using (var tx1 = session1.BeginTransaction())
using (var session2 = sessionFactory2.OpenSession())
using (var tx2 = session2.BeginTransaction())
{
    //Do work...
    tx1.Commit();
    tx2.Commit();
    ts.Complete();
}

answered Jun 11, 2010 at 17:01

Diego Mijelshon

52.7k16 gold badges119 silver badges159 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

learning Over a year ago

From where do we reference TransactionScope?

Gaz Over a year ago

TransactionScope is in System.Transactions. You can instaniate one anywhere. Incidentally I'm just waiting for the time to test this answer before I accept it!

Diego Mijelshon Over a year ago

@Pingpong no idea, depends on whether MySql supports transaction scopes.

Collectives™ on Stack Overflow

NHibernate with multiple databases and transactions

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related