NTEXT with more than 4000 characters in SQL Server CE in windows phone
I have a database in my windows phone app with a ntext
field in one of the tables, I'm trying to write some content to this field, but I get an InvalidOperationException
with the message:
String truncation: max=4000, len=4621
I am trying to use ntext
because I know that nvarchar
doesn't accept more than 4000 chars.
I've searched for a solution but I couldn't find any.
The only solution I found I cannot use on windows phone, because it uses the SqlConnection
and SqlCommand
with SqlDbType
.
Here is how the columns is declared:
private string _content;
[Column(DbType="ntext")]
public string Content
{
get
{
return _content;
}
set
{
if (value != _content)
{
_content = value;
NotifyChange(o => o.Content);
}
}
}
I'm inserting it with:
cn.Articles.InsertAllOnSubmit(articlesToSave);
cn.SubmitChanges();
Does anyone know any workaround?
Thanks for the answers in advance!!