public void ExecuteNonQueryTest() { DAO_Access.AccessDBHelper target = new DAO_Access.AccessDBHelper(); // TODO: Initialize to an appropriate value string sql = "update users set lastloginip='127.0.0.1'"; // TODO: Initialize to an appropriate value System.Data.OleDb.OleDbParameter[] parameters = null; // TODO: Initialize to an appropriate value int expected = 2; // TODO: Initialize to an appropriate value int actual; actual = target.ExecuteNonQuery(sql, parameters); Assert.AreEqual(expected, actual); }
public void ExecuteSql2DataSetTestNoData() { DAO_Access.AccessDBHelper target = new DAO_Access.AccessDBHelper(); string sql = "select * from users where userid=''"; System.Data.OleDb.OleDbParameter[] parameters = null; int startIndex = 0; int length = 5; string srcTable = string.Empty; System.Data.DataSet actual; actual = target.ExecuteSql2DataSet(sql, parameters, startIndex, length, srcTable); Assert.AreEqual(0, actual.Tables[0].Rows.Count); }
public void ExecuteScalarTest() { DAO_Access.AccessDBHelper target = new DAO_Access.AccessDBHelper(); // TODO: Initialize to an appropriate value string sql = "select userid from users where userid=@userid"; System.Data.OleDb.OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter() { ParameterName = "userid", Value = "Payne" } }; object expected = "Payne"; // TODO: Initialize to an appropriate value object actual; actual = target.ExecuteScalar(sql, parameters); Assert.AreEqual(expected, actual); }
public void ExecuteNonQueryTestWithParameters() { DAO_Access.AccessDBHelper target = new DAO_Access.AccessDBHelper(); // TODO: Initialize to an appropriate value string sql = "update users set lastloginip='127.0.0.1' where userid=@userid"; // TODO: Initialize to an appropriate value System.Data.OleDb.OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter() { ParameterName = "userid", Value = "Payne" } }; int expected = 1; // TODO: Initialize to an appropriate value int actual; actual = target.ExecuteNonQuery(sql, parameters); Assert.AreEqual(expected, actual); }
public void ExecuteSql2DataSetTestOneRecord() { DAO_Access.AccessDBHelper target = new DAO_Access.AccessDBHelper(); string sql = "select * from users where userid=@userid"; System.Data.OleDb.OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter() { ParameterName = "userid", Value = "Payne" } }; int startIndex = 0; int length = 0; string srcTable = string.Empty; System.Data.DataSet actual; actual = target.ExecuteSql2DataSet(sql, parameters, startIndex, length, srcTable); Assert.AreEqual(1, actual.Tables[0].Rows.Count); Assert.AreEqual("Payne", actual.Tables[0].Rows[0]["UserID"].ToString()); Assert.AreEqual("Payne Kang", actual.Tables[0].Rows[0]["Name"].ToString()); }