views:

255

answers:

0

I am not able to get an update to work using Linq to SQL on a VarChar(Max) field. Here is the code I use that is called from a simple DAO class:

public void UpdateContentById(int ContentId, string Content) {
    CkEditorDataContext db = new CkEditorDataContext();
    CkEditorContent dbContent = db.CkEditorContents.First(c => c.CkeId == ContentId);

    dbContent.CkeContent = "This is new content";

    db.SubmitChanges();
}

The CkeContent field is VarChar(Max). I noticed on this question: http://stackoverflow.com/questions/1511032/linq-to-sql-update-c
Marco seemed to have the same issue (see answer, 5th comment), but I can't tell if he ever got an answer for that particular issue.

Any help with this is greatly appreciated.