Fluent migrator. How to add datetime column with default values as current date?

fluent-migrator
Seth picture Seth · Jan 5, 2013 · Viewed 8.2k times · Source

How can I alter column in fluent migration with default date time value that is current date time?

So I need smth like this:

ALTER TABLE database ADD column DATETIME DEFAULT GETDATE() NOT NULL;

only for fluent migration. Thanks.

Answer

Chris Marisic picture Chris Marisic · Mar 18, 2016

Seeing as the answer doesn't actually include any code:

Create.Table(nameof(Report))
      .WithColumn(nameof(Report.Id)).AsInt32().NotNullable().PrimaryKey().Identity()
      .WithColumn(nameof(Report.CreatedAt)).AsDateTime().Nullable()
                                           .WithDefault(SystemMethods.CurrentDateTime);

The WithDefault(SystemMethods) method is the solution.

Related questions

Execute FluentMigrator migrations from code

Are there any tutorials or example code for executing FluentMigrator migrations from within code? Some "Getting Started..." tutorial would be just awesome. All I was able to find was FluentMigrator.Tests (unit tests), inside FluentMigrator source, which are not as …

Read More
Can I create a column of nvarchar(MAX) using FluentMigrator?

Using FluentMigrator, the default creation of a Column using .AsString() results in an nvarchar(255). Is there a simple way (before I modify the FluentMigrator code) to create a column of type nvarchar(MAX)?

Read More
Update row data with a new value per row using fluentmigrator

I am using fluentmigrator to add a new column to a table. I then want to update each row in the table with a unique value for that column. Currently when I use: Update.Table("Foo").InSchema("dbo").Set(new { …

Read More