public void GetAllBlogPosts_CheckCount()
{
int expected;
using (var cn = new SqlConnection(Settings.ConnectionString))
{
var cmd = new SqlCommand();
cmd.CommandText = "SELECT COUNT(BlogPostID) FROM BlogPosts";
cmd.Connection = cn;
cn.Open();
expected = int.Parse(cmd.ExecuteScalar().ToString());
}
var repo = new MVCBlogRepo();
Assert.AreEqual(expected, repo.GetAllBlogPosts().Count());
}
