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

This demonstrates how ADO.NET can provide disconnected access to data. Optimistic locking is an accepted standard for database updates from web pages. Optimistic locking allows records to remain unlocked until updates are applied. 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.

Automatically generated SQL