How to override Sql statement used by tableadapter to do updates
Posted on 2007-10-18
I am having issues with dbconcurrency exceptions, and I understand that a potential fix for this is to manually construct my update sql statements, rather than using the ones generated by vb.net.
How do I go about doing this?
I know how to create the update SQL statement for the current record in view, but it is possible to override the sql statement that will be used when asking the tableadapter to update all the changes, as in