When your database tables start accumulating thousands of rows and many users start working on the same table concurrently, SELECT queries on the tables start producing lock contentions and transaction deadlocks. This is a common problem in any high volume
Read More...
Read the complete post at http://feedproxy.google.com/~r/OmarAlZabirBlog/~3/zpw40Zu0jms/linq-to-sql-solve-transaction-deadlock-and-query-timeout-problem-using-uncommitted-reads.aspx