How do I setup a ROWVERSION/TIMESTAMP datatype column using FluentMigrator?

Question

I am trying to use the ROWVERSION (or TIMESTAMP) datatype on a SQL Server table for optimistic concurrency control.

My table is setup using FluentMigrator and I do not know how to get the datatype I need. According to Microsoft's article on ROWVERSION, a nonnullable ROWVERSION column is semantically equivalent to a binary(8) column; the nullable ROWVERSION datatype is equivalent to a varbinary(8).

Here is an example and as close as I can get...

public override void Up()
    {
        Create.Table("Test")
            .WithColumn("Id").AsInt32().Identity().PrimaryKey()
            .WithColumn("Description").AsAnsiString(255)
            .WithColumn("RowVersion").AsBinary(8).NotNullable(); 
    }

.WithColumn("RowVersion").AsBinary(8).NotNullable(); is the line I can't figure out... There is no .AsRowversion or .AsTimestamp option.

Thanks in advance!

I don't know FluentMigrator, sorry. But FluentNHibernate has a method Version(x => x.VersionProperty) in ClassMap<T>, that enables NHibernate optimistic locking (the property can be any of any integer type or DateTime). Is there nothing similar in FluentMigrator? — rumpelstiefel
– rumpelstiefel, Commented May 30, 2012 at 20:21

BueKoW · Accepted Answer · 2012-05-30 20:32:24Z

16

Wow! How something can be so simple that I look right over the obvious...

.WithColumn("Version").AsCustom("rowversion").NotNullable();

answered May 30, 2012 at 20:32

BueKoW

9765 gold badges18 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

How do I setup a ROWVERSION/TIMESTAMP datatype column using FluentMigrator?

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