Whenever Linq to Sql is running into an error (transaction deadlock, optimistic concurrency exception, etc), the Linq to Sql Profiler will detect that and show you the full error (including the exception message and the stack trace).