Share via

SqlBatchCommand.RecordsAffected Property

  • Reference

Definition

Namespace:
Microsoft.Data.SqlClient
Assembly:
Microsoft.Data.SqlClient.dll
Package:
Microsoft.Data.SqlClient v5.2.0

Gets the number of rows changed, inserted, or deleted by execution of this specific SqlBatchCommand.

public:
 property int RecordsAffected { int get(); };
public:
 virtual property int RecordsAffected { int get(); };
public int RecordsAffected { get; }
public override int RecordsAffected { get; }
member this.RecordsAffected : int
Public ReadOnly Property RecordsAffected As Integer
Public Overrides ReadOnly Property RecordsAffected As Integer

Property Value

Int32

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

Applies to