C# (CSharp) UnitTestHelpers.ExecuteSQLCode示例

示例#1

        public void TestFakeSproc2()
        {
            UnitTestHelpers.ExecuteSQLCode("UnitTestPersonSelector.TestData.TestFakeSproc2.sql");

            var     personSelector = new PersonSelector();
            DataSet data           = personSelector.ReadNames();

            Assert.AreEqual(3, data.Tables[0].Rows.Count);
        }

示例#2

        public void TestFakeSproc1()
        {
            UnitTestHelpers.ExecuteSQLCode("UnitTestPersonSelector.TestData.TestFakeSproc1.sql");

            var     personSelector = new PersonSelector();
            DataSet data           = personSelector.ReadNames();

            Assert.AreEqual(1, data.Tables[0].Rows.Count);
            Assert.AreEqual("Lisa", data.Tables[0].Rows[0]["first"].ToString());
        }