TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Kevin Coulombe
NA
2
0
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
Reply
Answers (
0
)
Database connectivity
2 basic transaction issues