SQL Server NOLOCK

[Thiago Conti]

Hello all,

I've just started using Simple.Data with SQL Server.

Could you help me with a simple question?

Is there a way to use something similar to NOLOCK (READ UNCOMMITED) when retrieving data?

Thanks in advance.

[Mike Woods]

I've spent all day looking into this as well.  From what I can tell, you can wrap a statement in a using a transaction.  

Here is some documenation on it: http://simplefx.org/simpledata/docs/pages/Tasks/UsingTransactions.html

using (var transaction = database.BeginTransaction())
{
   transaction.Users.Insert(Name: "Steve", Age: 50);
   transaction.Commit();
}

What they don't tell you here is that you can pass an IsolationLevel enum value into BeginTransaction so that it looks like this:

using (var transaction = database.BeginTransaction(IsolationLevel.ReadUncommitted))
{
   transaction.Users.Insert(Name: "Steve", Age: 50);
   transaction.Commit();
}

[Thiago Conti]

Thanks for your help!!!

--
You received this message because you are subscribed to the Google Groups "Simple.Data" group.
To unsubscribe from this group and stop receiving emails from it, send an email to simpledata+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.