EntityDataReader.RecordsAffected Property

Definition

Gets the number of rows changed, inserted, or deleted by execution of the SQL statement.

C#
public override int RecordsAffected { get; }

Property Value

The number of rows changed, inserted, or deleted. Returns -1 for SELECT statements; 0 if no rows were affected or the statement failed.

Remarks

The RecordsAffected property is not set until all rows are read and you close the DataReader.

Applies to

Product Versions
.NET Framework 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1