As somebody posted another issue here
http://llblgen.com/TinyForum/Messages.aspx?ThreadID=12054
I got exactly the same problem with him. When adding a note field in database using LLBLGen, if length of this field reaches 256 characters, an exception will be fired. But when I used a manual way to add the same field (using SqlCeCommand.ExecuteNonQuery() function), it worked!
This is what LLBLGen generated
base.AddElementFieldInfo("UserEntity", "Note", typeof(System.String), false, false, false, true, (int)UserFieldIndex.Note, 1500, 0, 0);
I did try this
int maxLength = UserEntity.Fields["Note"].MaxLength;
and it said 1500.
I have a friend who has worked with SQL CE 3.1 since Jan 2007 and he told me it's possible to store up to 4000 characters in a nvarchar field.
Have you guys got any thought for this?
Arthur.