I am trying to create a table on application start using PetaPoco. Since 2008 the column type ntext has been deprecated and replaced by nvarchar(MAX). ntext will be removed at some point. nvarchar allows for more operations on the column without having to cast or convert.
With MS SQL Server using nvarchar(n), n can be 0-4000 and MAX.
How do I create a nvarchar(MAX) column in Umbraco using PetaPoco? LengthAttribute is an int.
https://github.com/umbraco/Umbraco-CMS/tree/7.2.4/src/Umbraco.Core/Persistence/DatabaseAnnotations
SpecialDbTypes has ntext and nchar. I am (probably) missing something like a nvarcharmax special type or an enum allowing me to do:
[Column("Description")]
[SpecialDbType(SpecialDbTypes.NVARCHARMAX)]
public string Description { get; set; }
What is the Umbraco-way of creating a nvarchar column with more than 4.000 characters?
This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/66609-umbracocorepersistence-ntext-deprecated-nvarchar-max