FluentNHibernate - Setting default value for DB columns (SQL Server)

Question

does anyone know a way how I could set through mapping the default value of a column so for e.g. when I generate DB from mappings I would have DateTime column having getdate() as default value?

I tried so far this (looks exactlly like what I need) but it doesn't work

this.Map(x => x.LastPersistedOn, "DateModified") 
    .Access.Property() 
    .Default("getdate()");

I have the same issue in fluent 1.0 and there does not seem to be a solution - you can do it through events but this is not always appropriate. Anyone else? — row1
– row1, Commented Mar 9, 2010 at 2:22

Dom Ribaut · Accepted Answer · 2010-06-04 21:44:41Z

7

I just tried setting some default values and it worked as expected. I am using Fluent as retrieve from Git the 24.05.2010 so updating your copy may solve your problem.
Mapping

public class SampleEntity
{
    public virtual DateTime DateTimeProperty { get; set; }
}

With

 public class SampleEntityMap
        : ClassMap<SampleEntity>
{
   public SampleEntityMap()
   {
    Map(x => x.DateTimeProperty, "DateTimeColumn")
             .Access.Property()  //actually not necessary 
             .Not.Nullable()
             .Default("getDate()");
   }
}

this will produce the following sql (from output to the console)

create table SampleEntity(
   DateTimeColumn DATETIME default  getDate()  not null
  )

--
Dom

answered Jun 4, 2010 at 21:44

Dom Ribaut

3083 silver badges8 bronze badges

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

Comments

willemaster · Accepted Answer · 2010-04-09 12:40:00Z

4

The way to do this is to assign the current DateTime in code rather than using default value in the database. Then treat it as a normal column. Seemed a bit strange to me at first coming from a model-driven design background, but managing default values at the POCO level is the DDD way to do it.

Would be good to hear others' opinions too

edited Apr 9, 2010 at 12:40

answered Mar 23, 2010 at 22:44

willemaster

616 bronze badges

2 Comments

hometoast Over a year ago

The issue I have with this is it depends on the users clock. If not an end user if you have the application running in two different timezones it's already complicated enough.

DevTheo Over a year ago

Something else to think about is existing data. I know this is an old post, but if you are adding a new field to an existing class/table/map you don't always want the default value to be what would normally be the defualt (for instance a boolean column that you want the default to be true in all existing records)

Collectives™ on Stack Overflow

FluentNHibernate - Setting default value for DB columns (SQL Server)

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related