dotnet-db-samples | NET code samples for Oracle database developers | SQL Database library

while (DR.Read())
{
    count++;
    Field[] fields = new Field[DR.FieldCount];
    for (int i = 0; i < DR.FieldCount; i++)
    {
        Field field = new Field();
        field.RowCount = count;
        field.FieldCount = i;
        field.Name = DR.GetName(i);
        field.DataType = DR.GetDataTypeName(i);
        // decimal overflow workaround 
        field.ObjValue =
            field.DataType == "Decimal"?
            DR.GetDouble(i) :
            DR.GetValue(i);
        fields[i] = field;
    }
    yield return fields;
}

List ret = new List();
while (await DR.ReadAsync())
{
    count++;
    Field[] fields = new Field[DR.FieldCount];
    for (int i = 0; i < DR.FieldCount; i++)
    {
        Field field = new Field();
        field.RowCount = count;
        field.FieldCount = i;
        field.Name = DR.GetName(i);
        field.DataType = DR.GetDataTypeName(i);
        // decimal overflow workaround 
        field.ObjValue =
            field.DataType == "Decimal" ?
            ((object)await DR.GetFieldValueAsync(i)) :
            ((object)await DR.GetFieldValueAsync(i));
        fields[i] = field;
    }
    ret.Add(fields);
}

// decimal overflow workaround 
field.ObjValue =
    field.DataType == "Decimal" ?
    DR.GetDouble(i) :
    DR.GetValue(i);