Hangs with LINQ-SQL Server and TransactionScope?

This is not an MSDTC issue. If it were, you would get an error saying DTC is not enabled and needs to be. It's also not a deadlock issue, because you would get a specific error about that as well If I had to guess, I would say that the 'Other complicated code...' is attempting to perform a database operation and is being blocked by one or the other database context objects One way you can determine this is to run SQL Profiler to see what SQL statements are actually being executed on the server, and check for blocks.

This is not an MSDTC issue. If it were, you would get an error saying DTC is not enabled and needs to be. It's also not a deadlock issue, because you would get a specific error about that as well.

If I had to guess, I would say that the 'Other complicated code...' is attempting to perform a database operation and is being blocked by one or the other database context objects. One way you can determine this is to run SQL Profiler to see what SQL statements are actually being executed on the server, and check for blocks.

Actually, it turns out that the line of LINQ is causing the problem. More details are in my edited post. – Zian Choy Mar 19 '10 at 0:03.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.