I have several LinqToLLBL expressions that I would like to run under a snapshot isolation level (SQL Server 2008 ) to avoid any kind of blocks. I noticed, by default, the isolation level is set to read committed and that should suffice most of the situations but I need to use snapshot for a handful of queries.

Thank you,

Val

You can set the isolation level by creating the transaction manually

adapter.StartTransaction(IsolationLevel.ReadCommitted, "ReadTransaction");

I am using self-servicing though.

MTrinder wrote:

You can set the isolation level by creating the transaction manually

adapter.StartTransaction(IsolationLevel.ReadCommitted, "ReadTransaction");

Have a look at the documentation here

Yup, that is what I need.

Thank you.