SQL exception thrown from stored procedure does not raise exception in C#
Ref: https://taeguk.co.uk/blog/sqldatareader-gotcha/
It turns out if your stored proc returns multiple result sets followed by a THROW or RAISEERROR, the error is not thrown to C# if you only read one of the sets or (in my case) called ExecuteScalar.
Created By: amos 4/8/2020 4:56:09 PM
|
|