public void TestInsert()
{
DbObjects.SQLServer.DbObject db = new DbObjects.SQLServer.DbObject();
db.DbConnectStr = ConnStr;
Student student=new Student();
student.ID = 4;
student.StudentName = "Student4";
student.ClassName = "Class4";
student.Score = 30;
student.InTime=DateTime.Now;
Student stu2=new Student();
stu2.ID = 4;
stu2.StudentName = "stu5";
stu2.ClassName = "Class5";
stu2.Score = 40;
stu2.InTime = DateTime.Now;
Assert.AreEqual(db.ExceuteTrans(trans =>
{
db.Insert(student, trans);
db.Insert(stu2, trans);
return true;
}),true);
//Assert.AreEqual(db.Insert(student),true);
}
public void TestDelete()
{
DbObjects.SQLServer.DbObject db = new DbObjects.SQLServer.DbObject();
db.DbConnectStr = ConnStr;
Student student=new Student();
student.ID = 6;
Assert.AreEqual(db.Delete(student),true);
}
public void TestToSQL()
{
Student student = new Student();
student.ID = 4;
student.StudentName = "Student4";
student.ClassName = "Class4";
ExpressionToSQL tosql=new ExpressionToSQL();
tosql.ToSQL<Student>(c => c.ID == 1&&c.ClassName=="class1"&&c.Score>(decimal) 10.5&&c.InTime>DateTime.Now);
}
