Database

public partial class MyEntities : DbContext
{
    public MyEntities() : base("name=MyEntities")
    {
    }
    
    public MyEntities(string nameOrConnectionString) : base(nameOrConnectionString)
    {
    }
    
    public MyEntities(DbConnection existingConnection, bool contextOwnsConnection) : base(existingConnection, contextOwnsConnection)
    {
    }

Jörgen Andersson wrote:

The return statement is never reached, because the raiserror exits the statement block.

CREATE PROCEDURE dbo.SubSP1
AS
BEGIN
    PRINT 'Start SubSP1'
    RAISERROR('Some Error', 16,1) WITH LOG
    PRINT 'End SubSP1'
END
GO
-------Create SubSP2---------
CREATE PROCEDURE dbo.SubSP2
AS
BEGIN
    PRINT 'Inside SubSP2'
END

GO
-------Create MainSP---------
CREATE PROCEDURE dbo.MainSP
AS
BEGIN
    PRINT 'Start MainSP'
    EXEC dbo.SubSP1
    EXEC dbo.SubSP2 
    PRINT 'End MainSP'
END
GO

Start MainSP
Start SubSP1
Msg 50000, Level 16, State 1, Procedure SubSP1, Line 6
Some Error
End SubSP1
Inside SubSP2
End MainSP

Start MainSP
Start SubSP1
End SubSP1
Inside SubSP2
End MainSP
Msg 50000, Level 17, State 1, Procedure SubSP1, Line 5
Some Error

Kornfeld Eliyahu Peter wrote:

with the same parameters