If your tables gets so many query, your query results take so long
time. Avoid this issue, you can use SQL NOLOCK in your sql queries or
following linq to sql code heps to do this.
----------------------------------
using (var t = new TransactionScope(TransactionScopeOpti...
[More]