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 -~----------~----~----~----~------~----~------~--~---
