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); }