NHibernate: Oracle & PostgreSql

Question

I have an application that stores data in database (oracle) I have simple model

public class FileTemplate
{
    public string Xml { get; set; }
    ...
}

and class map

public class FileTemplateMap : ClassMap<FileTemplate>
{
    public FileTemplateMap()
    {
        Table("FILE_TEMPLATE");
        Map(f => f.Xml, "XML").CustomSqlType("NCLOB");
        ...
    }
}

A want to add PostgreSql support. But PostgreSql doesn't have NCLOB data type. I modify my mapping:

    public class FileTemplateMap : ClassMap<FileTemplate>
    {
        public FileTemplateMap()
        {
            Table("FILE_TEMPLATE");
#if POSTGRE
            Map(f => f.Xml, "XML").CustomSqlType("TEXT");
#else
            Map(f => f.Xml, "XML").CustomSqlType("NCLOB");
#endif
        }
    }

Now I have to do different builds for oracle and postgresql with defining conditional compilation symbols (for postgresql). And application that build with POSTGRE compilation symbol doesn't work with oracle.

Are there other ways to do this without using conditional compilation symbols? I want to have one build, that works with both databases.

user208567 · Accepted Answer · 2013-08-09 12:57:00Z

1

I'd do something like this

public static class CustomSqlTypeHelpers
{
    static readonly string _ClobSqlType;

    static CustomSqlTypeHelpers()
    {
        // Checks to validate config file setting ommitted
        _ClobSqlType = ConfigurationManager.AppSettings["ClobSqlType"];
    }

    public static PropertyPart LargeTextColumn(this PropertyPart pp)
    {
        return pp.CustomSqlType(_ClobSqlType);
    }
}

public FileTemplateMap()
{
    Table("FILE_TEMPLATE");
    Map(f => f.Xml, "XML").LargeTextColumn()
}

answered Aug 9, 2013 at 12:57

user208567

Sign up to request clarification or add additional context in comments.

Comments

Maxim · Accepted Answer · 2013-08-11 14:01:37Z

0

I've done a little differently. Here is an article about my solution: http://beamyplum.blogspot.ru/2013/08/nhibernate.html

answered Aug 11, 2013 at 14:01

Maxim

1,6132 gold badges12 silver badges16 bronze badges

Collectives™ on Stack Overflow

NHibernate: Oracle & PostgreSql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related