If you need that isolation level for anything you can set it as default in
nh-config.

2009/9/19 [email protected] <[email protected]>

>
> The DBA's I work with gave us a similar issue but it was on SQL Server
> and they wanted WITH(NOLOCK) added to every select/join.  Using a
> transaction isolation level of ReadUncommitted gives us the
> equivalent.  Not sure if it will do the same for you in DB2 or not.
>
> using (session.BeginTransaction(IsolationLevel.ReadUncommitted)
> return session.CreateCriteria<Type>().List<Type>();
>
> On Sep 18, 7:08 pm, Newbie <[email protected]> wrote:
> > We are using NHibernate to interact with DB2 ZOS. For general selects,
> > we would like NHibernate to execute all selects with "WITH UR"
> > keyword  to perform dirty reads. We are new to NHibernate. Any ideas
> > on how we can automatically append "WITH UR" to all select statements?
> > Thanks in advance.
> >
>


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

Reply via email to