will a client application using ado.net get an exception if the command is executing a stored proced

[Daniel]

will a client application using ado.net get an exception if the command is
executing a stored procedure that does a RAISEERROR in its tsql?

 

[Nicholas Paldino [.NET/C# MVP]]

Daniel,

Well, you could try it very easily (and probably have it done in the
time it took for you to get this response).

But the answer is yes. =) It should throw a SqlException.

Hope this helps.

 

[Guest]

Yes.

 

[Guest]

Actually, a little more thorough answer. Yes. The client will get a
SqlException with SqlException.Number set to 50000 by default or whatever you
set your error number to in your call to RAISERROR.

 

[W.G. Ryan - MVP]

As an fyi, if you get an error with a lower severity number, you can trap it
with the infomessage event:
http://www.knowdotnet.com/articles/connections.html

 

[Guest]

Very interesting article. I wasn't familiar with the infomessage event
before. I'll have to look for an opportunity to try it out.