1

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.

Ricky
  • 32,609
  • 37
  • 88
  • 131

1 Answers1

2

SET NOCOUNT ON and reading messages using C# and ADO.NET

SqlConnection.InfoMessage Event

Community
  • 1
  • 1
Svetlozar Angelov
  • 20,444
  • 6
  • 61
  • 67