For some reason,
var connString ="Data Source=ServerName;InitialCatalog=DatabaseName;Integrated Security=true;"
SqlConnection conn = new SqlConnection(connString);
SqlCommand someCmd = new SqlCommand("SELECT COUNT(*) FROM SomeTable");
someCmd.Connection = conn;
var theCount = cmd.ExecuteNonQuery();
SELECT COUNT(*) FROM SomeTable;
Based on MSDN:
For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. When a trigger exists on a table being inserted or updated, the return value includes the number of rows affected by both the insert or update operation and the number of rows affected by the trigger or triggers. For all other types of statements, the return value is -1. If a rollback occurs, the return value is also -1.
You want to return the number of rows affected by the command and save it to an
int variable but since the type of statement is
select so it returns
Solution: If you want to get the number of rows affected by the SELECT command and save it to an int variable you can use
var theCount = (int)cmd.ExecuteScalar();