Possible to default DateTime field to GETDATE() with Entity Framework Migrations?

adammokan picture adammokan · Dec 21, 2011 · Viewed 38.7k times · Source

I added EntityFramework.Migrations (Beta 1) to an existing Code-First app that is going through some changes (for both migration capabilities and more fine-tuning of the tables I am generating from my code-first API) and ran into the GETDATE() scenario.

I was already using a custom initializer class in my DbContext to run SQL scripts to set some fields and create indexes in my database. A handful of my AlterTable scripts are primary just to setup fields with default values(such as certain DateTime fields being set to GETDATE()). I was really hoping EntityFramework.Migrations would have an answer for this since you can easily specify defaultValue, but so far I'm not seeing one.

Any ideas? I was really hoping that doing the following would magically work. (It is 'magic unicorn', after all)

DateCreated = c.DateTime(nullable: false, defaultValue: DateTime.Now)

Unfortunately, and logically, it set my default value to the time when the Update-Database command was executed.

Answer

gius picture gius · Jan 30, 2012

You can use

DateCreated = c.DateTime(nullable: false, defaultValueSql: "GETDATE()")

Usage:

public partial class MyMigration : DbMigration
{
    public override void Up()
    {
        CreateTable("dbo.Users",
            c => new
                {
                    Created = c.DateTime(nullable: false, defaultValueSql: "GETDATE()"),
                })
            .PrimaryKey(t => t.ID);
 ...

Update 2012-10-10:

As requested by Thiago in his comment, I add a little extra context.

The code above is a migration-file generated by EF Migrations by running Add-Migration MyMigration as a command in the package manager console. The generated code is based on the models in the DbContext associated with migrations. The answer suggests that you modify the generated script so that a default value is added when the database is created.

You can read more about Entity Framework Code First Migrations here.