• Getting NHibernate to generate a HiLo string ID


    We've got a large system that's loosely bound to its data source (Navision) via Unity - we're getting the opportunity to swap it out and have our own database.

    So we've had a look around and really like the look of Fluent NHibernate - we're trying to get a proof of concept going and swap out a couple of the services.

    We want to use NHibernates HiLo algorithm - Unfortunately we've inherited string ID's from Navision which prefixs its ID's (example COL00001) so to match the Interface we need to use string Id's.

    Does anyone know how I'd get something like ...

    Id(x => x.ID).GeneratedBy.HiLo("100");
    

    working where ID is a string? We're currently getting Identity must be int, long etc

    Thanks,

    Andy

    ------ Update ------

    I tried the example in the article suggested but this functionality has been removed from later versions of Fluent NHibernate - there is however a .Custom - but I can't seem to get it working!

    public class ManufacturerMap : ClassMap<Manufacturer>
    {
        public ManufacturerMap()
        {
            Id(x => x.ID).GeneratedBy.Custom(typeof(StringTableHiLoGenerator));
            Map(x => x.Name);
        }
    }
    
    
    public class StringTableHiLoGenerator : TableHiLoGenerator
    {
        public override object Generate(ISessionImplementor session, object obj)
        {
            return base.Generate(session, obj).ToString();
        }
    }
    
    

    Finally cracked it ... thanks for you assistance - heres the solution in case anyones interested?

    Note that in the Configure method the IType has to be passed to the base as an int.

    public class ManufacturerMap : ClassMap<Manufacturer>
    {
        public ManufacturerMap()
        {
            Id(x => x.ID).GeneratedBy.Custom<StringTableHiLoGenerator>(a => a.AddParam("max_lo", Nexus3General.HiLoGeneratorMaxLoSize.ToString()));
            Map(x => x.Name);
        }
    }
    
    public class StringTableHiLoGenerator : TableHiLoGenerator
    {
        public override object Generate(ISessionImplementor session, object obj)
        {
            return base.Generate(session, obj).ToString();
        }
    
        public override void Configure(IType type, System.Collections.Generic.IDictionary<string, string> parms, NHibernate.Dialect.Dialect dialect)
        {
            base.Configure(NHibernateUtil.Int32, parms, dialect);
        }
    }
    
     
     
     
     
     
  • 相关阅读:
    redis 日常使用
    centos7新装mysql 5.7
    spring 的常用功能
    软件安装教程
    每日成长17年1月
    ubuntu下不用拔盘就可以重新识别usb设备
    使用Linux遇到的一些问题和解决方案
    在XEN上启动guest时loopback设备不足
    使用virtualenv搭建python虚拟开发环境
    Linux局域网登陆响应时间过长
  • 原文地址:https://www.cnblogs.com/aaa6818162/p/3955266.html
Copyright © 2020-2023  润新知