public EnumerateColumnsResponse CreateTable(DbModifyRequest request) { try { var options = new TransactionOptions() { IsolationLevel = System.Transactions.IsolationLevel.Serializable, Timeout = new TimeSpan(0, TransactionTimeout, 0) }; using (var trScope = new TransactionScope(TransactionScopeOption.Required, options)) { var rzlt = new EnumerateColumnsResponse(); rzlt.Columns.AddRange(GetTableColumns(request.Table, true)); rzlt.IsSuccess = true; string logMsg = String.Format("Table {0} was created.", request.Table); Guid historyRecordId = LogTableOperation(request.Table, logMsg, request.CFC_DB_Major_Version, request.CFC_DB_Minor_Version); trScope.Complete(); return(rzlt); } } catch (Exception ex) { return(new EnumerateColumnsResponse() { IsSuccess = false, ErrorMessage = ex.Message }); } }
public EnumerateColumnsResponse EnumerateColumns(string tableName) { try { var options = new TransactionOptions() { IsolationLevel = System.Transactions.IsolationLevel.Serializable, Timeout = new TimeSpan(0, TransactionTimeout, 0) }; using (var trScope = new TransactionScope(TransactionScopeOption.Required, options)) { var rzlt = new EnumerateColumnsResponse(); rzlt.Columns.AddRange(GetTableColumns(tableName)); rzlt.IsSuccess = true; trScope.Complete(); return(rzlt); } } catch (Exception ex) { return(new EnumerateColumnsResponse() { IsSuccess = false, ErrorMessage = ex.Message }); } }