Last post Nov 01, 2007 04:13 PM by vsakunala
Nov 01, 2007 02:56 PM|vsakunala|LINK
So, I changed the UpdateCheck to "UpdateCheck=System.Data.DLinq.UpdateCheck.WhenChanged" and got "SQL Server does not handle comparison of NText, Text, Xml, or Image data types ". Got the same error when
the setting changed to "UpdateCheck=System.Data.DLinq.UpdateCheck.Always"
Any suggestions please
Blinq LINQ auto-generate web forms
Nov 01, 2007 03:58 PM|phuff|LINK
Hi Vijay- this is one of the topics covered in the Known Issues section of the readme:
Tables that contain only primary key columns that are identity fields and fields specified as never participating in optimistic concurrency throw an ArgumentNullException on update.
Due to a bug in LINQ, these columns will fail with an ArgumentNullException error that references a parameter named "body". Work around this issue by either changing
UpdateCheck to UpdateCheck.WhenChanged, or by adding another field to the entity.
It sounds like you tried one of the two workarounds suggested in the readme. Have you tried adding another field to the entity?
This is a bug in the Linq preview that has been fixed in more recent builds. I hope one of these workarounds will work until there is something to replace the Blinq preview.
Nov 01, 2007 04:13 PM|vsakunala|LINK
Thanks Polita Paulus,
The Column is not primary/identity field. I am able to update other coulmn types that are int, nvarchar. So I am not sure adding another field will help. The error happens only when updating ntext column. This problem is in all pages that update ntext
type database field.