public void GetNullableString_DbNullDataRecordValue_ShouldReturnNull()
{
var dataRecord = new SqlDataRecord(
new SqlMetaData("StringProp", SqlDbType.NVarChar, 20),
new SqlMetaData("IntProp", SqlDbType.Int));
dataRecord.SetValue(1, 123);
Assert.Equal(null, dataRecord.GetNullable <string>(0));
}
public void GetNullableInt_DbNullDataRecordValue_ShouldReturnZero()
{
var dataRecord = new SqlDataRecord(
new SqlMetaData("StringProp", SqlDbType.NVarChar, 20),
new SqlMetaData("IntProp", SqlDbType.Int));
dataRecord.SetValue(0, "String value.");
Assert.Equal(0, dataRecord.GetNullable <int>(1));
}
public void GetNullable_InvalidOrdinal_ShouldThrowException()
{
var dataRecord = new SqlDataRecord(
new SqlMetaData("StringProp", SqlDbType.NVarChar, 20),
new SqlMetaData("IntProp", SqlDbType.Int));
dataRecord.SetValue(0, "String value.");
dataRecord.SetValue(1, 123);
Assert.Throws <IndexOutOfRangeException>(() => dataRecord.GetNullable <string>(3));
}
public void GetNullableInt_ValidIntValue_ShouldReturnIntValue()
{
const int IntValue = 123;
var dataRecord = new SqlDataRecord(
new SqlMetaData("StringProp", SqlDbType.NVarChar, 20),
new SqlMetaData("IntProp", SqlDbType.Int));
dataRecord.SetValue(0, "String value.");
dataRecord.SetValue(1, IntValue);
Assert.Equal(IntValue, dataRecord.GetNullable <int>(1));
}
public void GetNullableString_ValidStringValue_ShouldReturnStringValue()
{
const string StringValue = "String value.";
var dataRecord = new SqlDataRecord(
new SqlMetaData("StringProp", SqlDbType.NVarChar, 20),
new SqlMetaData("IntProp", SqlDbType.Int));
dataRecord.SetValue(0, StringValue);
dataRecord.SetValue(1, 123);
Assert.Equal(StringValue, dataRecord.GetNullable <string>(0));
}
