2

This is a slight variation of this question. If I have a function that performs an action that returns a value but I did not capture that value in a variable, is there any way I can get that value while stepping through with the debugger without running the function a 2nd time in the immediate window?

A practical example

using (SqlConnection cnSqlConnect = OpenConnection(ConnectionString))
using (SqlCommand sqlCmd = new SqlCommand(command, cnSqlConnect))
{
    sqlCmd.ExecuteNonQuery();
}

Is there any way to get the value of sqlCmd.ExecuteNonQuery() without running it twice?

Community
  • 1
  • 1
Scott Chamberlain
  • 124,994
  • 33
  • 282
  • 431

1 Answers1

4

Yes there is!

  1. Break on the function before it executes.
  2. From the Command Window run the line of code you stopped on, prepended with a ? to view the results. Like this: ? sqlCmd.ExecuteNonQuery();
  3. Manually drag the yellow pointer showing the next line of code to be executed down to the next line, skpping over the code that you ran in the command window.

This will have the effect of only executing your code once and will let you view the result.

For more information see the Basics of using the Command Window.

Scott Chamberlain
  • 124,994
  • 33
  • 282
  • 431
  • Your answer to my Dup gave me the idea for the solution to this problem :). It can't be used for the other problem because running the command has side effects, but if you are not returning and just throwing the value away, your solution works. (If you make an answer I will upvote yours and delete mine) – Scott Chamberlain Jun 01 '13 at 02:34