Alex Rivera | Logout

Linq to SQL error SQL does not compare NText, Text, Xml, or Image?

Asked 2009-05-15T15:27:47.117
12

When trying to do an update for a Linq object I receive the following error.

"SQL Server does not handle comparison of NText, Text, Xml, or Image data types."

There is a field in the database that is a Text field because it is going to hold a string that could be as much as 32kb.

Should I change the data type or is there a work around in Linq I could use?

EDIT

I have support SQL 2000 which is why it is a TEXT field.

Edit
Report

1 Answer

1

You can manually change the Update Check to "Never" in the .dbml.

answered 2011-02-24T09:53:47.113

Your Answer