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