Firebird ADO.NET Provider SDK Documentation - v1.7

FbCommand.ExecuteNonQuery Method 

Executes an the query and returns the number of rows affected.

[Visual Basic]
NotOverridable Public Function ExecuteNonQuery() As Integer _
    Implements IDbCommand.ExecuteNonQuery
[C#]
public int ExecuteNonQuery();

Return Value

For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1.

Implements

IDbCommand.ExecuteNonQuery

Remarks

Although ExecuteNonQuery does not return any rows, any output parameters or return values mapped to parameters are populated with data.

IMPORTANT: To execute this method you need to have a FbTransaction associated to the command.

Exceptions

Exception TypeCondition
InvalidOperationException

The connection does not exist.

-or-

The connection is not open.

-or-

The transaction is not valid.

See Also

FbCommand Class | FirebirdSql.Data.Firebird Namespace