Fluent NHibernate mapping to Oracle 11G and SQLite

Question

On an already in place table in the database we are trying to Add a column for the CreationDate

mapping.Map(x => x.CreationDate)
            .Not.Nullable()
            .Default("to_date('01-01-0001','dd-MM-yyyy')")

This works perfectly fine with oracle but SQLite will not understand this, which is perfectly normal because it does not know the to_date() function.

If i use

DateTime.MinValue.ToString()

for the Default value with or without an specific format. Then it will work in SQLite but it wont work in Oracle.

Does someone know a solution to solve this.

Firo · Accepted Answer · 2012-09-19 13:19:00Z

1

leave out the defaultvalue and write a convention

class CreationDateConvention  : IPropertyConvention
{
    public CreationDateConvention(string default)
    {
        _default = default;
    }

    public void Apply(... instance)
    {
        if (instance.Name == "CreationDate")
            instance.Default(_default)
    }
}


// and while configuring
...FluentMappings.AddFromAssemblyOf<>().Conventions.Add(new CreationDateConvention(isOracle ? "to_date..." : Datetime.Minvalue.ToString())

answered Sep 19, 2012 at 13:19

Firo

30.8k4 gold badges57 silver badges97 bronze badges

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

Collectives™ on Stack Overflow

Fluent NHibernate mapping to Oracle 11G and SQLite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related