public void GetAllArchivedStaticPages_CheckCount()
{
int expected;
using (var cn = new SqlConnection(Settings.ConnectionString))
{
var cmd = new SqlCommand();
cmd.CommandText = "SELECT COUNT(StaticPageID) FROM StaticPages WHERE [Status] = 3";
cmd.Connection = cn;
cn.Open();
expected = int.Parse(cmd.ExecuteScalar().ToString());
}
var repo = new MVCBlogRepo();
Assert.AreEqual(expected, repo.GetAllArchivedStaticPages().Count());
}
