Since you are spiking NH and TS behavior the first thing I would do is
remove the repository abstraction and work with NH directly.
IIRC The TS needs to be defined before opening the session.
using(var ts = new TransactionScope())
using(var session = factory.OpenSession())
{
session.Save(new Entity());
ts.Complete();
}
start from this point and add tests to see what the results are.
On Jan 14, 3:25 pm, HH <[email protected]> wrote:
> Hi All,
>
> I'am trying to find out the best practices for using
> System.Transactions.TransactionScope with NHibernate.
> I have created some unit tests to find out what works and what doesn't
> work. I am stuck with a couple of questions:
>
> First, when I execute the following code (sorry for dutch naming):
>
> [TestMethod]
> public void CanCommitNestedTransactionWhenOuterTransactionIsAborted()
> {
> long medewerkerId1 = 2;
> long medewerkerId2 = 3;
> string voornaam1;
> string voornaam2;
>
> // NHibernate Session will be openend on first call to repository
>
> IMedewerkerRepository repository = this.CreateRepository();
>
> using (TS.TransactionScope scope1 = new TS.TransactionScope()) {
> // Update m1 in scope1.
> Medewerker m1 = repository.Get(medewerkerId1);
> voornaam1 = m1.Voornaam;
> m1.Voornaam = DateTime.Now.ToString();
> repository.Update(m1);
>
> // Update m2 in nested scope2 -> RequiresNew
> using (TS.TransactionScope scope2 = new TS.TransactionScope
> (TransactionScopeOption.RequiresNew)) {
> Medewerker m2 = repository.Get(medewerkerId2);
> voornaam2 = m2.Voornaam;
> m2.Voornaam = DateTime.Now.ToString();
> repository.Update(m2);
>
> scope2.Complete(); // scope 2 is completed
> }
>
> //NB: scope1 is not completed
> }
>
> Medewerker mCheck1 = repository.Get(medewerkerId1);
> Medewerker mCheck2 = repository.Get(medewerkerId2);
>
> Assert.AreEqual(voornaam1, mCheck1.Voornaam);
> Assert.AreNotEqual(voornaam2, mCheck2.Voornaam);
>
> // TestCleanup will dispose session
>
> }
>
> So scope1 should not be commited and scope2 should (in my opinion) be
> committed because it is a seperate transaction (RequiresNew). To my
> supprise both scopes are not committed, why, isn't RequiresNew
> supported by NHibernate?
>
> Second question:
>
> Consider the following test:
>
> [TestMethod]
> public void CanRollbackTransaction() {
> long medewerkerId = 2;
> string voornaam;
>
> // NHibernate Session will be openend on first call to repository
>
> IMedewerkerRepository repository = this.CreateRepository();
>
> using (TS.TransactionScope scope = new TS.TransactionScope()) {
> Medewerker m = repository.Get(medewerkerId);
> voornaam = m.Voornaam;
>
> m.Voornaam = DateTime.Now.ToString();
>
> repository.Update(m);
>
> //NB: scope is not completed
> }
>
> Medewerker mCheck = repository.Get(medewerkerId);
>
> Assert.AreEqual(voornaam, mCheck.Voornaam);
>
> // TestCleanup will dispose session
>
> }
>
> This test does not pass although scope is rollbacked in the database.
> It looks like the session cache does not get updated (no call to db in
> NHProf). The second "Get" gets it's value from the cache and that
> still is the updated (but rollbacked) data. When I create my own
> wrapper arround TransactionScope and call ISession.Clear() on the
> current NHibernate session the test passes. But is this the way to go?
>
> I am a bit stuck on how to use System.Transactions.TransactionScope
> with NHibernate. I need to use the TransactionScope class because of
> other db activity outside NHibernate in the same transaction.
>
> Kind regards,
> Henk Huisman
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
