Esempio n. 1
0
        public void CreateStaticPageDB()
        {
            var staticPage = new StaticPage()
            {
                Date = DateTime.Today,
                Mce = new TinyMceClass()
                {
                    Body = "Unit Test for CreateStaticPageDB method"
                },
                StaticPageID = 0,
                Status = 2,
                Title = "Testing",
                UserID = "2598e14d-88d0-46a7-ace9-f323ffe89181"
            };

            var repo = new MVCBlogRepo();
            repo.CreateStaticPageDB(staticPage);

            var cn = new SqlConnection(Settings.ConnectionString);

            var expected = cn.Query<int>("SELECT COUNT(StaticPageID) FROM StaticPages").FirstOrDefault();

            Assert.AreEqual(expected, 6);
        }