Unable to use NOLOCK when using simple data adapter

markrendle / Simple.Data

A light-weight, dynamic data access component for C# 4.0

MIT License

1.33k stars 302 forks source link

Unable to use NOLOCK when using simple data adapter #401

Open abhayksingh opened 6 years ago

abhayksingh commented 6 years ago

I am unable to use NOLOCK on the table using Simple.data, this is required as the table is getting constantly getting inserted/updated or read. Any help is appreciated. I am using FindAll to select the rows.

WayneHiller commented 6 years ago

Can you use a stored procedure? Set the isolation level to read uncommitted.?