Data Browser - Viewing Site  Sector 23 Code Bank Logged in as:  Guest  




           


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