Hi guys

Any plans to support transaction save points? (Or is it somehow already supported?!)

I have a data access pattern the employs something called a SessionUsage. It picks up the underlying connection iusing the thread context. This way I can easily flow transactions.

using(SessionUsage usage = new SessionUsage())
{
usage.BeginTransaction(); // savepoint here

// do stuff

usage.CommitTransaction();
}

Now if the SessionUsage gets disposed after beginning a transaction, but without a commit having occured, I want to roll back to the beginning of the save point.

Is there are way of doing this easily, or perhaps a different architecture which would achieve the same thing?

Thanks.

Anyone?

I think the problem with transaction save points is that the session will no longer be in a consistent state if you roll back the DB transaction, whether or not it's to a save point. If *any* database modification action fails, for whatever reason, you're supposed to throw away the session and start with a new one.

It would be nice if NHibernate supported transactions that covered the in memory state of the objects as well so that they could be rolled back, but I doubt we'll be seeing that anytime soon.

Symon.