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();