gpt4 book ai didi

c# - SqlDataReader 检查空值的最佳方法-sqlDataReader.IsDBNull 与 DBNull.Value

转载 作者:可可西里 更新时间:2023-11-01 08:14:50 28 4
gpt4 key购买 nike

我想从数据库中检索十进制值,我想知道检查空值的推荐方法是什么。

我在 MSDN - DBNull.Value Field 上看到过很少使用此检查。

因此,reader.IsDBNull 是检查空值的最佳/最有效方法吗?

我创建了 2 个示例方法:

public static decimal? GetNullableDecimal(SqlDataReader reader, string fieldName)
{
if (reader[fieldName] == DBNull.Value)
{
return null;
}
return (decimal)reader[fieldName];
}

public static decimal? GetNullableDecimal_2(SqlDataReader reader, string fieldName)
{
if (reader.IsDBNull(reader[fieldName]))
{
return null;
}
return (decimal)reader[fieldName];
}

大多数情况下,字段将为空。

提前致谢!

最佳答案

我不会太在意哪种方法更好,因为这两种方法都有效,而且我之前在代码中都使用过。

例如,这是我从我的一个旧项目中挖出的实用函数:

/// <summary>
/// Helper class for SqlDataReader, which allows for the calling code to retrieve a value in a generic fashion.
/// </summary>
public static class SqlReaderHelper
{
private static bool IsNullableType(Type theValueType)
{
return (theValueType.IsGenericType && theValueType.GetGenericTypeDefinition().Equals(typeof(Nullable<>)));
}

/// <summary>
/// Returns the value, of type T, from the SqlDataReader, accounting for both generic and non-generic types.
/// </summary>
/// <typeparam name="T">T, type applied</typeparam>
/// <param name="theReader">The SqlDataReader object that queried the database</param>
/// <param name="theColumnName">The column of data to retrieve a value from</param>
/// <returns>T, type applied; default value of type if database value is null</returns>
public static T GetValue<T>(this SqlDataReader theReader, string theColumnName)
{
// Read the value out of the reader by string (column name); returns object
object theValue = theReader[theColumnName];

// Cast to the generic type applied to this method (i.e. int?)
Type theValueType = typeof(T);

// Check for null value from the database
if (DBNull.Value != theValue)
{
// We have a null, do we have a nullable type for T?
if (!IsNullableType(theValueType))
{
// No, this is not a nullable type so just change the value's type from object to T
return (T)Convert.ChangeType(theValue, theValueType);
}
else
{
// Yes, this is a nullable type so change the value's type from object to the underlying type of T
NullableConverter theNullableConverter = new NullableConverter(theValueType);

return (T)Convert.ChangeType(theValue, theNullableConverter.UnderlyingType);
}
}

// The value was null in the database, so return the default value for T; this will vary based on what T is (i.e. int has a default of 0)
return default(T);
}
}

用法:

yourSqlReaderObject.GetValue<int?>("SOME_ID_COLUMN");
yourSqlReaderObject.GetValue<string>("SOME_VALUE_COLUMN");

关于c# - SqlDataReader 检查空值的最佳方法-sqlDataReader.IsDBNull 与 DBNull.Value,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/18550769/

28 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com