I was getting below error when I was trying to execute a LINQ query inside the TransactionScope.System.Data.SqlClient.SqlException: MSDTC on server '' is unavailable. Solution
The solution of this problem is to start the MSDTC service (find Distributed Transaction Coordinator
in the Administrative Tools > Services) on the machine where this query is being executed.
Hope this helps.