Able to Select with NOLOCK

I am wrapping my connecting within a transaction, where there are some reads (selects). However, some of these selects could be with NOLOCK.
Is there any possibility to specify this in the Select?

The latest v5.7.1 on MyGet you can use the new NoLock SQL Server Table Hint, e.g:

var q = db.From<Car>()
    .Join<Car, CarType>((c, t) => c.CarId == t.CarId, SqlServerTableHint.NoLock);

Otherwise you can customize the generated SQL with a Custom SqlExpression Filter,

1 Like

Thanks! Exactly what I needed!