Add WITH(NOLOCK) clause in SELECT SQL query

[mukarramjavid]

Hi @borisdj ,
Is there any plan to add the WITH(NOLOCK) clause in the SELECT statement within the BulkRead() method?
For example,
SELECT * FROM Employees WITH(NOLOCK)

Thanks

[LeDahu22]

@mukarramjavid Maybe with (readpast) would be preferable, otherwise you could read uncommited dirty data.

[mukarramjavid]

@mukarramjavid Maybe with (readpast) would be preferable, otherwise you could read uncommited dirty data.

@borisdj Yes, it is preferable. However, if you make it optional, the user can choose whether to add NO(LOCK) / READPAST or not, similar to WITH(HOLDLOCK). What do you think?