title: Retrieve error message from SQL Server when using SP in SQL to LINQ
body: <p>I'm having some trouble with my error handling in my ASP.NET MVC 2 application. I'm using LINQ to SQL for ORM and am only using Stored Procedures for getting and changing data in the SQL Server. My SP use TryAndCatch blocks, and raiseerrors. But when calling a SP in my client application that raises an error the clientapp just goes on. My goal is to get the clientapp to go to the catch block and there retrieve the error message that the SP raised. Is this possible? If so, could someone be so kind and give me some hints?</p>
  
  <p>Tim</p>
  
  <p><em>This post asked pretty much the same question, but the answer didn't help to much :/</em></p>
  
  <p><a href="https://stackoverflow.com/questions/687964/how-do-you-get-full-error-information-for-a-stored-procedure-error-out-of-linq-to">How do you get full error information for a stored procedure error out of LINQ-to-SQL or SQL Server?</a></p>