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();
}
Try / Catch?
using (Entities context = new Entities())
{
try
{
IEnumerable<EmployeeDetails> empDetails = context. Database.SqlQuery <EmployeeDetails>("exec GetEmployeeData ", null).ToList();
}
Catch (SqlException ex)
{
//Do something
}
}