Optimistic concurrency misses varchar fields?

Jan 15 2009 10:34 AM
I am trying to create a very simple typed dataset using the designer in VS2005 to connect to my Article table on an SQL Server 2005 Express database, nothing out of the ordinary. I want to use optimistic concurrency because there will be many user working on that table.

But it seems that when I drag my table on the dataset designer's surface from the server explorer window, it does not create the update and delete queries correctly for concurrency issues detection. There are filters missing on the varchar(MAX) fields so another user may modify the article's content and I won't even know it when I overwrite their change.

This is shown on the screenshots I attached. You can see there is no filter on any of the VARCHAR(MAX) columns.

Is this caused by the full-text search option being disabled? It seems to solve the problem if I modify the DELETE and UPDATE queries manually, but I'm looking to know why it generates them that way and how I can make it work correctly instead of modifying all my queries manually (that's hours of boring work). Performance isn't an excuse to cut the corners that rough...

Article table structure.JPG
Article delete query.JPG