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); }); }