Hello everybody!
I have a problem with a length of ntext field - when I create field of that type, it's length property is constant and is equal to 16. When I run my application, and insert a string composed of 499 characters, I get following message: "The data was truncated while converting from one data type to another. [ Name of function(if known) = ]". So now I have two questions - one: it's clear to me, that ntext field may hold a really long strings, so why this 16 keeps appearing as a default value of the length property? And the second - what am I doing wrong :D ?
ps. I'm using LinqToSql.