public void SQLExecutionTest()
{
SQLExecution.SqlCommandParameters param = new SqlCommandParameters()
{
CommandTimeOut = 60,
DatabaseName = "",
SqlServerInstance = "",
StoredProcedure = "",
UseIntegratedSecurity = false,
UserId = "",
Password = ""
};
using (SQLExecution.SqlExecution exec = new SqlExecution())
{
exec.AddToList(param);
exec.Run();
using (System.Data.DataSet set = exec.Commands[0].SqlExecution.Data)
{
Assert.IsNotNull(set);
Assert.IsTrue(set.Tables[0].Rows.Count > 0);
}
}
}
public void SQLCommandExecutionTest()
{
SQLExecution.SqlCommandParameters param = new SqlCommandParameters()
{
CommandTimeOut = 60,
DatabaseName = "",
SqlServerInstance = "",
StoredProcedure = "",
UseIntegratedSecurity = false,
UserId = "",
Password = ""
};
SQLExecution.SqlCommandExecution cmd = new SqlCommandExecution(param);
cmd.Execute();
System.Data.DataSet set = cmd.Data;
Assert.IsNotNull(set);
Assert.IsTrue(set.Tables[0].Rows.Count > 0);
cmd.Dispose();
}
