MigratorDotNet and Text Datatype on SQL Server 2008

269 views Asked by At

I am using migratordotnet to sync my SQLServer 2008 database and need to create a column of type Text...

Am at a bit of a loss as to how to do this, as there is no System.Data.DbType.Text??

1

There are 1 answers

0
Boycs On BEST ANSWER

Worked it out with some trial and error...

DbType of AnsiString and a length of int.MaxValue does the trick

Database.AddColumn("Notification", "Body", DbType.AnsiString, int.MaxValue);