MigratorDotNet and Text Datatype on SQL Server 2008

287 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 best solutions below

0
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);