CODEWITHSUNDEEP
fluent-migrator
Remi Despres-Smyth
Remi Despres-Smyth

Reputation: 4253

Is it possible to set column default to SQL Server's NewId()?

In fluentMigrator, is it possible to set a column default to a function?

Specifically, I'm adding a uniqueidentifier (Guid) column to a SQL Server 2008 table that already contains data, and it's going to be a required field - is it possible to set the default to the NewId() function?

Upvotes: 11

Views: 3657

Answers (1)

Remi Despres-Smyth
Remi Despres-Smyth

Reputation: 4253

Field defaults for NewId() and GetDate() are available (for SQL Server at least) by referring to either SystemMethods.NewGuid or SystemMethods.CurrentDateTime, for example:

Create
    .Column("incomeIdGuid").OnTable("tblIncome")
    .AsGuid()
    .NotNullable()
    .WithDefaultValue(SystemMethods.NewGuid);

Upvotes: 23

Related Questions