private static REF.Metadata setResultSchema(DbDataReader dataReader)
{
var metadata = new REF.Metadata();
var schema = dataReader.GetColumnSchema();
if (!schema.IsValid())
{
return(metadata);
}
foreach (var row in schema)
{
metadata.Columns.Add(new REF.Column(row.ColumnName, row.DataType.FullName, row.ColumnOrdinal.GetValueOrDefault(0)));
}
return(metadata);
}
private static void getRowData(SqlDataReader dataReader, REF.Metadata metadata, ICollection <Row> Rows)
{
var row = new Row();
foreach (var column in metadata.Columns)
{
if (dataReader.IsDBNull(column.ColumnIndex))
{
row.Add(column.ColumnName, null);
}
else
{
DataResolver.Resolve(column.ColumnDataType, dataReader, row, column.ColumnName, column.ColumnIndex);
}
}
Rows.Add(row);
}
