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