Entity Model and Concurrency

KW · Post by KW » Mon 21 Feb 2011 18:33

I generated an entity model and set a properties concurrency mode to fixed.

I then opened db monitor to make sure it was submitting the correct sql statement. It doesn't seem to be submitting the correct sql statement. It needs to add an additional parameter in the where clause. Does the concurrency work correctly?

AndreyR · Post by **AndreyR** » Tue 22 Feb 2011 12:54

Could you please give a more detailed description of the problem?
If possible, please send us a small test project illustrating the issue.

KW · Post by KW » Tue 22 Feb 2011 16:27

AndreyR wrote:Could you please give a more detailed description of the problem?
If possible, please send us a small test project illustrating the issue.

Using Entity Developer, I set a property's concurrency mode to Fixed. Shouldn't this add an a parameter to the update statement so it looks like:

update table1 set prop1 = :prop1 where prop1 = :propr1OriginalValue, id = :id

AndreyR · Post by **AndreyR** » Wed 23 Feb 2011 11:38

I have made a simple check and the Update statement contained the expected WHERE clause. Could you please provide the test project?

KW · Post by KW » Thu 24 Feb 2011 16:46

AndreyR wrote:I have made a simple check and the Update statement contained the expected WHERE clause. Could you please provide the test project?

Ok. Let me double check everything first and then I will repost here if I am sitll having issues. And I will provide a sample project.