Microsoft Visual Basic.NET automatically generates code similar to that shown on the left.  This particular code is the default style (optimistic locking) generated for a web form.

This demonstrates that ADO.NET provides disconnected access to data.  Optimistic locking is an accepted standard for database updates from web pages. Often times, records may include a "last updated by" and "last updated date/time". If that is the case, you should consider excluding those two fields from the where clause. At least, you should consider those fields separately.