SerialSebFluent-nhibernate and nvarchar(max)
As you may know, text and ntext types are being depreciated in sql server 2005+, and replaced by varchar(max) and nvarchar(max).
If like me you rely on nhibernate to generate your database, the trick for getting nvarchar(max) is to set the length of the field to 10000. I wrote a small extension method to do this.
public static class PropertyMapExtensions
{
public static PropertyMap WithMaxSize(this PropertyMap map)
{
return map.WithLengthOf(10000);
}
}
I use the automapping functionality, so this is what it then looks like.
AutoPersistenceModel.MapEntitiesFromAssemblyOf<Movie>()
.Where(t => t.Namespace == (typeof(Entity).Namespace) && !t.IsAbstract && t.IsPublic)
.ForTypesThatDeriveFrom<Movie>(x =>
{
x.Map(m => m.LongSynopsis).WithMaxSize();
x.Map(m => m.Notes).WithMaxSize();
})
.Configure(configuration);