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

fluent-migrator
Darren Oster picture Darren Oster · Mar 23, 2010 · Viewed 16.8k times · Source

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)?

Answer

Jon Cahill picture Jon Cahill · Jul 4, 2010

You could create an extension method to wrap .AsString(Int32.MaxValue) within .AsMaxString()

e.g.

internal static class MigratorExtensions
{
    public static ICreateTableColumnOptionOrWithColumnSyntax AsMaxString(this ICreateTableColumnAsTypeSyntax createTableColumnAsTypeSyntax)
    {
        return createTableColumnAsTypeSyntax.AsString(int.MaxValue);
    }
}

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
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
Is it possible to use fluent migrator in application_start?

I'm using fluent migrator to manage my database migrations, but what I'd like to do is have the migrations run at app start. The closest I have managed is this: public static void MigrateToLatest(string connectionString) { using (var announcer = new …

Read More