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);
}
}
}
/// <summary>
/// Synchronous process with a connection and a transaction
/// </summary>
/// <param name="execute">execution with a connection and a transaction</param>
public void Process(SqlExecution <C, T> execute)
{
Process((connection) =>
{
Transaction(connection, execute);
});
}
