public void TestUpate2() { DbObjects.SQLServer.DbObject db = new DbObjects.SQLServer.DbObject(); db.DbConnectStr = ConnStr; db.Update("sore="+db.GetParameterName("sore"), "where sore>=100", "students", null,new KeyValuePair<string, object>(db.GetParameterName("sore"),50)); }
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 TestDelete2() { DbObjects.SQLServer.DbObject db = new DbObjects.SQLServer.DbObject(); db.DbConnectStr = ConnStr; Assert.AreEqual(db.Delete("where sore<" + db.GetParameterName("sore"), "students", null, new KeyValuePair <string, object>(db.GetParameterName("sore"), 50)), true); }
public void TestIsExist() { DbObjects.SQLServer.DbObject db = new DbObjects.SQLServer.DbObject(); db.DbConnectStr = ConnStr; Assert.AreEqual(db.IsExist(new Student() { ID = 1 }), true); }
public void TestUpate2() { DbObjects.SQLServer.DbObject db = new DbObjects.SQLServer.DbObject(); db.DbConnectStr = ConnStr; db.Update("sore=" + db.GetParameterName("sore"), "where sore>=100", "students", null, new KeyValuePair <string, object>(db.GetParameterName("sore"), 50)); }
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 TestQueryModels() { DbObjects.SQLServer.DbObject db = new DbObjects.SQLServer.DbObject(); db.DbConnectStr = ConnStr; var models = db.QueryModels<Student>("select * from td_student"); Assert.AreEqual(models.Count>0 ,true); }
public void TestDelete2() { DbObjects.SQLServer.DbObject db = new DbObjects.SQLServer.DbObject(); db.DbConnectStr = ConnStr; Assert.AreEqual(db.Delete("where sore<" + db.GetParameterName("sore"), "students", null, new KeyValuePair<string, object>(db.GetParameterName("sore"), 50)),true); }
public void TestQueryModels() { DbObjects.SQLServer.DbObject db = new DbObjects.SQLServer.DbObject(); db.DbConnectStr = ConnStr; var models = db.QueryModels <Student>("select * from td_student"); Assert.AreEqual(models.Count > 0, 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 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 TestIsExist() { DbObjects.SQLServer.DbObject db = new DbObjects.SQLServer.DbObject(); db.DbConnectStr = ConnStr; Assert.AreEqual(db.IsExist(new Student() { ID = 1 }), true); }
public void TestUpdate() { DbObjects.SQLServer.DbObject db = new DbObjects.SQLServer.DbObject(); db.DbConnectStr = ConnStr; Student student = db.QueryModel<Student>("select * from td_student where id=" + db.GetParameterName("id"), new KeyValuePair<string, object>(db.GetParameterName("id"), 6)); student.ID =6; student.StudentName = "Studentfsafasfasf"; student.ClassName = "Class4sfasdfas"; student.InTime=DateTime.Now; student.Score = 30; db.Update(student); }
public void TestUpdate() { DbObjects.SQLServer.DbObject db = new DbObjects.SQLServer.DbObject(); db.DbConnectStr = ConnStr; Student student = db.QueryModel <Student>("select * from td_student where id=" + db.GetParameterName("id"), new KeyValuePair <string, object>(db.GetParameterName("id"), 6)); student.ID = 6; student.StudentName = "Studentfsafasfasf"; student.ClassName = "Class4sfasdfas"; student.InTime = DateTime.Now; student.Score = 30; db.Update(student); }