>我有一个TimeSpan属性,我想使用Nhibernate将其保存到DB。Mysql 列类型为时间。我读到了这一点
自定义类型("TimeAsTimeSpan")
应该解决问题,但它没有。
会期。保存(对象)
将导致以下 MySqlException
只有 TimeSpan 对象可以通过 MySqlTimeSpan 错误进行序列化
im 尝试保留的时间戳属性是有效的时间戳。有什么好感吗?
这是 NHibernate 中的一个错误。我刚刚设法通过创建TimeAsTimeSpan类的克隆来解决此问题。
用法:
CustomType(typeof(TimeAsTimeSpanTypeClone));
类:
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using NHibernate.Engine;
using NHibernate.SqlTypes;
using NHibernate.Type;
namespace DataAccess.NhibernateFixes
{
/// <summary>
/// Clone of the Nhibernate class: NHibernate.Type.TimeAsTimeSpanType
/// This one actually works though...
/// </summary>
[Serializable]
public class TimeAsTimeSpanTypeClone : PrimitiveType, IVersionType, IType, ICacheAssembler
{
private static readonly DateTime BaseDateValue = new DateTime(1753, 1, 1);
public override string Name
{
get
{
return "TimeAsTimeSpan";
}
}
public override System.Type ReturnedClass
{
get
{
return typeof(TimeSpan);
}
}
public IComparer Comparator
{
get
{
return (IComparer)Comparer<TimeSpan>.Default;
}
}
public override System.Type PrimitiveClass
{
get
{
return typeof(TimeSpan);
}
}
public override object DefaultValue
{
get
{
return (object)TimeSpan.Zero;
}
}
static TimeAsTimeSpanTypeClone()
{
}
public TimeAsTimeSpanTypeClone()
: base(SqlTypeFactory.Time)
{
}
public override object Get(IDataReader rs, int index)
{
try
{
object obj = rs[index];
if (obj is TimeSpan)
return (object)(TimeSpan)obj;
else
return (object)((DateTime)obj).TimeOfDay;
}
catch (Exception ex)
{
throw new FormatException(string.Format("Input string '{0}' was not in the correct format.", rs[index]), ex);
}
}
public override object Get(IDataReader rs, string name)
{
try
{
object obj = rs[name];
if (obj is TimeSpan)
return (object)(TimeSpan)obj;
else
return (object)((DateTime)obj).TimeOfDay;
}
catch (Exception ex)
{
throw new FormatException(string.Format("Input string '{0}' was not in the correct format.", rs[name]), ex);
}
}
public override void Set(IDbCommand st, object value, int index)
{
DateTime dateTime = TimeAsTimeSpanTypeClone.BaseDateValue.AddTicks(((TimeSpan)value).Ticks);
((IDataParameter)st.Parameters[index]).Value = (object)dateTime.TimeOfDay; // <<<< fix here. Added ".TimeOfDay"
}
public override string ToString(object val)
{
return ((TimeSpan)val).Ticks.ToString();
}
public object Next(object current, ISessionImplementor session)
{
return this.Seed(session);
}
public virtual object Seed(ISessionImplementor session)
{
return (object)new TimeSpan(DateTime.Now.Ticks);
}
public object StringToObject(string xml)
{
return (object)TimeSpan.Parse(xml);
}
public override object FromStringValue(string xml)
{
return (object)TimeSpan.Parse(xml);
}
public override string ObjectToSQLString(object value, NHibernate.Dialect.Dialect dialect)
{
return (string)(object)''' + (object)((TimeSpan)value).Ticks.ToString() + (string)(object)''';
}
}
}
好吧,由于没有人回答我的问题,并且我尝试了许多不同的方法都没有结果,我决定采取解决方法。插入到 varchar 列类型(不再是时间类型)时,我将时间戳对象转换为字符串,并在从数据库读取时将字符串转换回时间戳对象。这是该转换的代码,以防万一。
DateTime.Parse(startTimebtn.Text).TimeOfDay.ToString();