コード例 #1
0
        public void TestSql()
        {
            PeopleModel p1 = DbEntry.ExecuteList <PeopleModel>("Select [Id],[Name] From [People] Where [Id] = 2")[0];

            Assert.AreEqual("Jerry", p1.Name);
            p1 = DbEntry.ExecuteList <PeopleModel>(new SqlStatement("Select [Name],[Id] From [People] Where [Id] = 1"))[0];
            Assert.AreEqual("Tom", p1.Name);
            p1 = PeopleModel.FindBySql("Select [Id],[Name] From [People] Where [Id] = 2")[0];
            Assert.AreEqual("Jerry", p1.Name);
            p1 = PeopleModel.FindBySql(new SqlStatement("Select [Name],[Id] From [People] Where [Id] = 3"))[0];
            Assert.AreEqual("Mike", p1.Name);
        }