SQLOLEDB updates Microsoft® SQL Server™ data when a consumer updates a modifiable rowset containing that data. A modifiable rowset is created when the consumer requests support for either the IRowsetChange or IRowsetUpdate interface.
All SQLOLEDB modifiable rowsets use SQL Server cursors to support the rowset. The OLE DB rowset property DBPROP_LOCKMODE alters SQL Server concurrency control behavior in cursors and determines the behavior of rowset row fetching and data integrity error generation in updatable rowsets.
SQLOLEDB supports row synchronization before or after an update.