8. Свод событий ADO.NET

Следующие таблицы содержат события, генерируемые компонентами ADONET.

DataSetCommand Events

Method/Property	Sequence of events
Update( )	OnStateChange, if connection is closed. OnRowUpdating, one event per row. OnRowUpdated, one event per row. OnStateChange, if connection was initially closed.
InsertCommand property is changed	OnSchemaChanging OnSchemaChanged
SelectCommand property is changed	OnSchemaChanging OnSchemaChanged
UpdateCommand property is changed	OnSchemaChanging OnSchemaChanged
DeleteCommand property is changed	OnSchemaChanging OnSchemaChanged
TableMappings or ColumnMappings are changed	OnSchemaChanging (SchemaType.Mapped) OnSchemaChanged
FillDataSetSchema(...)	OnStateChange (if connection is closed) OnSchemaMapping — Issued once per result set when the mapping between result set and DataTable is complete. OnStateChange (if connection is closed initially)
FillDataSet(...)	OnStateChange (if connection is closed) OnSchemaMapping — Issued once per result set when the mapping between result set and DataTable is complete. OnStateChange (if connection is closed initially)

Connection Events

Method/Property	Sequence of events
Open()	OnStateChange
Close()	OnStateChange
BeginTransaction()	OnStateChange
CommitTransaction()	OnStateChange
RollbackTransaction()	OnStateChange
Informational message set from the server	OnInfoMessage

Command Events

Method/Property	Sequence of events
ActiveConnection property is changed	OnSchemaChanging OnSchemaChanged
CommandType property is changed	OnSchemaChanging OnSchemaChanged
CommandText property is changed	OnSchemaChanging OnSchemaChanged
Parameters property is changed	OnSchemaChanging OnSchemaChanged
ResetParameters	OnSchemaChanging OnSchemaChanged