public void TestGetSqlStetementByExecuteList()
{
List <Person> ls = DbEntry.ExecuteList <Person>("SELECT * FROM [People] WHERE Id > ? AND Id < ?", 1, 3);
Assert.AreEqual(1, ls.Count);
Assert.AreEqual("Jerry", ls[0].Name);
}
public void Test3()
{
var ls = DbEntry.ExecuteList <UnsignedPC>("select * from PCs where [Id] = 1");
Assert.AreEqual(1, ls.Count);
Assert.AreEqual("IBM", ls[0].Name);
Assert.AreEqual(2, ls[0].Person_Id);
}
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);
}
public void Test3WithSql()
{
List <NullableTable> ls = DbEntry.ExecuteList <NullableTable>(
"select * from NullTest where Id = 3");
Assert.AreEqual(1, ls.Count);
NullableTable o = ls[0];
Assert.IsNotNull(o);
Assert.AreEqual(3, o.Id);
Assert.AreEqual(null, o.Name);
Assert.IsTrue(null == o.MyInt);
Assert.IsTrue(null == o.MyBool);
}
public Role()
{
_permissionList = new Lazy <List <Permission> >(() => DbEntry.ExecuteList <Permission>(
"SELECT * FROM [Permission] WHERE [Id] IN (" +
"SELECT [Permission_Id] FROM [Role_Permission] WHERE [Role_Id] = ?)", this.Id));
}
