Search code examples
entity-frameworksql-server-2008stored-proceduressql-server-2012throw

How to handle store procedure exception message to entity framework


How to catch the RAISEERROR or SQL 2012 - THROW exception from sql store procedure to entity framework - store procedure call ?

using (Entities context = new Entities())
{
        IEnumerable<EmployeeDetails> empDetails  =  context. Database.SqlQuery
                                                                      < EmployeeDetails >("exec GetEmployeeData ", null).ToList();
}

Solution

  • Try / Catch?

    using (Entities context = new Entities())
    {
        try
        {
            IEnumerable<EmployeeDetails> empDetails  =  context. Database.SqlQuery                                                            <EmployeeDetails>("exec GetEmployeeData ", null).ToList();
        }
        Catch (SqlException ex)
        {
            //Do something
        }
    }