Connection InfoMessage Event Handler

thomlamb

How can I add a InfoMessage Event Handler to the current connection I'm using?

Something like this:

myConnection.InfoMessage += new SqlInfoMessageEventHandler(myConnection_InfoMessage);

void myConnection_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
myStringBuilderDefinedAsClassVariable.AppendLine(e.Message);
}

JoeAlbahari

You should be able to do this within the query:

((SqlConnection)Connection).InfoMessage += (sender, args) => args.Message.Dump();

or:

((SqlConnection)Connection).InfoMessage += (sender, args) =>
    Util.SqlOutputWriter.WriteLine (args.Message);

thomlamb

great thanks!