How to read SQL Server COUNT from SqlDataReader
Code Example - How to read SQL Server COUNT from SqlDataReader
string sql = "SELECT COUNT(*) FROM [DB].[dbo].[myTable]";
SqlCommand cmd = new SqlComman(sql, connectionString);
int count = (int)cmd.ExecuteScalar();