ADO.NET: What API I can use to get message when SET NOCOUNT OFF

Question

Hi guys:

Many articles recommend adopting "SET NOCOUNT ON" to avoid receiving message like "1 Row(s) affected".

I'm curious what ADO.NET API I can use to get message when SET NOCOUNT OFF.

Thanks.

Answer 1

http://stackoverflow.com/questions/1724404/set-nocount-on-and-reading-messages-using-c-and-ado-net

SqlConnection.InfoMessage Event