protected void BaseFixtureSetup() { var db = new TempDbSqlDatabase(); SQLConnection = db.CreateConnection(); SQLConnection.Open(); }
private static DataTable ExecuteSql(string sqlStatements, SqlConnection connection) { using (var comm = new SqlCommand(sqlStatements, connection)) { comm.CommandType = CommandType.Text; comm.CommandTimeout = CommandTimeoutInSeconds; var sqlResult = TempDbSqlDatabase.ExecuteSqlCommand(comm); if (sqlResult.Tables.Count > 0) { return(sqlResult.Tables[0]); } return(null); } }