// usage
var name = GetValueOrDefault<string>(reader, "Name");
var name = reader.GetValueOrDefault<string>("Name");
var name = reader.GetValueOrDefault<string>(0);
// extension
public static T GetValueOrDefault<T>(this IDataRecord row, string fieldName)
{
int ordinal = row.GetOrdinal(fieldName);
return row.GetValueOrDefault<T>(ordinal);
}
public static T GetValueOrDefault<T>(this IDataRecord row, int ordinal)
{
return (T)(row.IsDBNull(ordinal) ? default(T) : row.GetValue(ordinal));
}
Technorati tags:
C-Sharp,
ADO.Net,
CodeProject-Tip