Text/Nvarchar data mapping based on data size (Kea/Tui).


Nvartext & varbinary has a size limit, Text & Image don't but have a size and performance overhead. So it's best to use nvarchar/varbinary when you can, and text/varbinary when you need to.
So the idea is to have the ability to have two columns map to the same property. e.g. OrderXml nvarchar(1000) & OrderXmlBig Text. With Kea or Tui doing the mapping based on the maxlength of the nvarchar/varbinary column and the data being stored.