/// <summary>
/// Create a new GetTableColumns_Result object.
/// </summary>
/// <param name="tableName">Initial value of the TableName property.</param>
public static GetTableColumns_Result CreateGetTableColumns_Result(global::System.String tableName)
{
GetTableColumns_Result getTableColumns_Result = new GetTableColumns_Result();
getTableColumns_Result.TableName = tableName;
return getTableColumns_Result;
}
private LookupTable DecorateFlatTable(string name, GetTableColumns_Result[] tableColumns, bool includeRows = true)
{
var ratingTable = new LookupTable(name)
{
Keys =
tableColumns.Where(p => p.IsKey != null && p.IsKey == true).Select(
p => new FactorTableColumnDefinition(p.ColumnName, true)
{
LookupType = (LookupType)Enum.Parse(typeof(LookupType), p.LookupType, true)
}).ToArray(),
Columns =
tableColumns.Where(p => p.IsKey != null && p.IsKey == false).Select(
p => new FactorTableColumnDefinition(p.ColumnName, false)).ToArray()
};
if (includeRows)
{
var allColumns = ratingTable.Keys.Concat(ratingTable.Columns).ToArray();
//RatingTablesDb.Connection.Open();
RatingTableQuery(
FlatTableQueries.BuildVersionedQuery(ratingTable.Name, allColumns.Select(p => p.Name).ToArray(), EffectiveDate),
reader => ReadLookupTableRows(ratingTable, reader));
}
return ratingTable;
}