I'm not worried about the design. I don't mind implicits here because it is a very small unit of work. I'm looking for an answer of why I may not be seeing the transaction against the DB.
On Sep 9, 10:34 am, Jason Dentler <[email protected]> wrote: > http://nhprof.com/Learn/Alert?name=AvoidImplicitRollback<http://nhprof.com/Learn/Alert?name=AvoidImplicitRollback> > > On Wed, Sep 9, 2009 at 9:20 AM, [email protected] < > > [email protected]> wrote: > > > There doesn't need to be any commit in this. It is a readonly query. > > The DBA has enforced that for all selects, we either put WITH(NOLOCK) > > on every join/table OR we read everything inside of a ReadUncommitted > > transaction. I was just using the implicit rollback from IDisposable. > > > On Sep 9, 9:37 am, Fabio Maulo <[email protected]> wrote: > > > the commit ?Where is it ? > > > > 2009/9/9 [email protected] <[email protected]> > > > > > Given that I have the following: > > > > > using (session.BeginTransaction(IsolationLevel.ReadUncommitted)) { > > > > return session.CreateCriteria<T>().List(); > > > > } > > > > > The DBA I work with has been complaining that he can't see the > > > > transaction in SQL Profiler. He's used all the standard transaction > > > > events and didn't see a thing. I did use the SQLTransaction event and > > > > saw some transactions appear to be starting but without the isolation > > > > level. > > > > > Can anyone offer some advice on where I should be looking or what I > > > > may be doing wrong to begin with!? > > > > -- > > > Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
