Re: DBConcurrencyException - Update problem

[Yvan Rodrigues]

This is true in that it will make the problem go away, but it doesn't fix anything.

I am assuming you are using a MySqlCommandBuilder.

By either setting MySqlCommandBuilderConflictOption.OverwriteChanges (5.0.x) or setting the second argument in the contructor (LastOneWins) to true (1.0.x) you are basically telling the class to ignore concurrency and just let the last write be the one that is written. This is probably fine for a lot of stuff.

However; if you are actually looking for concurrency management, you need to dig deeper to find the problem.

I have experienced this, but only when one of the fields is float or double.

Tell us more, search the forums, check the bugs, use the Google.