我正在尝试在我的应用程序中支持UInt32。通过查看这个位置给出的示例,我编写了代码。NHibernate-如何在数据库中存储UInt32。在我的hbm文件中,我定义了属性标签:
<property name="Uint16Var" column="Uint16Var"
type="datatypeSupported.UInt32Type, datatypeSupported" />
我还定义了一个UInt32Type类,如下所示:
using System;
using NHibernate;
using NHibernate.SqlTypes;
using NHibernate.UserTypes;
namespace datatypeSupported
{
public class UInt32Type : IUserType
{
public object NullSafeGet(System.Data.IDataReader rs, string[] names, object owner)
{
int? i = (int?)NHibernateUtil.Int32.NullSafeGet(rs, names[0]);
return (UInt32?)i;
}
public void NullSafeSet(System.Data.IDbCommand cmd, object value, int index)
{
UInt32? u = (UInt32?)value;
int? i = (Int32?)u;
NHibernateUtil.Int32.NullSafeSet(cmd, i, index);
}
public Type ReturnedType
{
get
{
return typeof(Nullable<UInt32>);
}
}
public SqlType[] SqlTypes
{
get
{
return new SqlType[] { SqlTypeFactory.Int32 };
}
} public object Assemble(object cached, object owner)
{
return cached;
}
public object DeepCopy(object value)
{
return value;
}
public object Disassemble(object value)
{
return value;
}
public int GetHashCode(object x)
{
return x.GetHashCode();
}
public bool IsMutable
{
get { return false; }
}
public object Replace(object original, object target, object owner)
{
return original;
}
public new bool Equals(object x, object y)
{
return x != null && x.Equals(y);
}
}
}
但当我试图保存我的实体时,它仍然会给出一个错误"Dialect不支持DbType.UInt32"。我需要做什么类型的更改?
编写一个自定义方言,为UInt32
类型添加支持。根据您正在使用的数据库,从一种已知的方言继承。也就是说,对于SQL Server,您可以有这样的东西:
public class CustomMsSqlDialect : MsSql2008Dialect
{
protected override void RegisterNumericTypeMappings()
{
base.RegisterNumericTypeMappings();
RegisterColumnType(DbType.UInt32, "INT");
}
}
使用FluentHibernate注册方言:
Fluently.Configure().Database(
MsSqlConfiguration.MsSql2008.Dialect<CustomMsSqlDialect>()...)
使用XML:
<property name="dialect">CustomMsSqlDialect, AssemblyName</property>