Database error handling in entity framework

Question

I wrote stored procedure witch sometimes RAISERROR(). I execute it through the entity framework like:

using( MyModelEntities conn = new MyModelEntities() ) {
    conn.MyStoredProcedure(input_p, output_p);
}

Stored procedure:

create procedure dbo.MyStoredProcedure(
    @input   nvarchar(255),
    @output int out
)
as
begin
    ...
        RAISERROR (N'My Exception....', 10, 1);
    ...
end
go

Is there any opportunity to get information about error?

Utkarsh Patel · Accepted Answer · 2016-06-23 14:14:55Z

4

In sql server exception level 1 to 10 are informational and does not raise error back to your application.

change Level in between 11 to 16 to raise error from the SP.

answered Jun 23, 2016 at 14:14

Utkarsh Patel

3253 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dweiss · Accepted Answer · 2012-05-01 14:03:55Z

2

Can this just be put into a try/catch with the exception displayed? Or maybe you could try going into debug mode?

answered May 1, 2012 at 14:03

dweiss

8324 silver badges9 bronze badges

2 Comments

nosbor Over a year ago

Btw. I was too fast... RAISERROR is not returning exception. Only Sql Server Erorrs... So how can I handle my Custom errors?

ssis_ssiSucks Over a year ago

Are you catching an instance of SqlException in your Try/Catch block, and using its Messsage or Errors properties?: (msdn.microsoft.com/en-us/library/…)

CodeGrue · Accepted Answer · 2013-02-21 20:55:07Z

0

Here is how I handle this:

create procedure dbo.MyStoredProcedure(
    @input   nvarchar(255),
    @output  text out
)
as
begin
    ...
      SELECT @message = convert(varchar, getdate(), 108) + ': My Exception....'
      SET @output = CAST(@message AS text) -- send message to c#/.net
      RAISERROR(@message,0,1) WITH NOWAIT  -- send message to SQL Server Management Studio
    ...
end
go

Then on the C#/EF side:

public string CallMyStoredProcedure(string input)
{
    var outputParameter = new ObjectParameter("output", typeof(string));
    EntityContext.MyStoredProcedure(input, outputParameter);
    return (string)outputParameter.Value;
}

answered Feb 21, 2013 at 20:55

CodeGrue

5,9336 gold badges47 silver badges63 bronze badges

Collectives™ on Stack Overflow

Database error handling in entity framework

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related