public void run()
{
#region Simple Tests
//string str="";
string sql;
OleDbConnection con = null;
sql = "UPDATE Employees SET Region = ?, TitleOfCourtesy = ? WHERE EmployeeID=1";
con = new OleDbConnection(MonoTests.System.Data.Utils.ConnectedDataProvider.ConnectionString);
//not testing with DB2 provider
if (ConnectedDataProvider.GetDbType(con) != DataBaseServer.DB2)
{
OleDbCommand cmd = new OleDbCommand(sql, con);
cmd.Parameters.Add(new OleDbParameter("Region", OleDbType.VarWChar));
cmd.Parameters.Add(new OleDbParameter("TitleOfCourtesy", OleDbType.VarWChar));
con.Open();
cmd.Parameters["Region"].Value = "WA";
cmd.Parameters["TitleOfCourtesy"].Value = "Mr";
//return the number of rows affected
int i = cmd.ExecuteNonQuery();
try
{
BeginCase("Check row count");
Compare(i, 1);
}
catch (Exception ex) { exp = ex; }
finally{ EndCase(exp); exp = null; }
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
#endregion
#region Test Parameter Types
#region General
TypesSubTests(ConnectedDataProvider.GetSimpleDbTypesParameters());
TypesSubTests(ConnectedDataProvider.GetExtendedDbTypesParameters());
#endregion
#endregion
}
public void run()
{
DoTestTypes(ConnectedDataProvider.GetSimpleDbTypesParameters());
DoTestTypes(ConnectedDataProvider.GetExtendedDbTypesParameters());
}
