public static DateTime GetDateTime(this DbDataRecord dr, string columnName)
{
Check.ArgNotNull(dr, nameof(dr));
int ordinal = dr.GetOrdinal(columnName);
return(dr.GetDateTime(ordinal));
}
public void GetEnumeratorTest()
{
this.fixture.ExecuteCommand(command => {
command.CommandText = "SELECT * FROM ORDERS";
using (var reader = command.ExecuteReader()) {
IEnumerator enumerator = reader.GetEnumerator();
while (enumerator.MoveNext())
{
DbDataRecord record = (DbDataRecord)enumerator.Current;
Assert.Equal(reader.FieldCount, record.FieldCount);
Assert.Equal(reader.GetInt32(0), record.GetInt32(0));
Assert.Equal(reader.GetString(1), record.GetString(1));
Assert.Equal(reader.GetInt32(2), record.GetInt32(2));
Assert.Equal(reader.GetDateTime(3), record.GetDateTime(3));
Assert.Equal(reader.GetDateTime(4), record.GetDateTime(4));
Assert.Equal(reader.GetValue(5), record.GetValue(5));
Assert.Equal(reader.GetInt32(6), record.GetInt32(6));
Assert.Equal(reader.GetDecimal(7), record.GetDecimal(7));
reader.Read();
}
}
});
}
/// <summary>
/// GetNullSafeDateTime() - Checks the DateTime column to be accessed and if it is DBNull,
/// the DateTime.MinValue constant will be returned.
/// </summary>
/// <param name="rec">Database Record</param>
/// <param name="colIndex">Column Index</param>
/// <returns>Actual DateTime or MinValue (if null)</returns>
public DateTime GetNullSafeDateTime(DbDataRecord rec, int colIndex)
{
return(rec.IsDBNull(colIndex) ? DateTime.MinValue : rec.GetDateTime(colIndex));
}
