Database.ExecuteNonQuery Method (DbTransaction, String, array<Object[])

Executes the storedProcedureName using the given parameterValues within a transaction and returns the number of rows affected.

Namespace:  Microsoft.Practices.EnterpriseLibrary.Data
Assembly:  Microsoft.Practices.EnterpriseLibrary.Data (in Microsoft.Practices.EnterpriseLibrary.Data.dll)

Syntax

'Declaration
Public Overridable Function ExecuteNonQuery ( _
    transaction As DbTransaction, _
    storedProcedureName As String, _
    ParamArray parameterValues As Object() _
) As Integer

public virtual int ExecuteNonQuery(
    DbTransaction transaction,
    string storedProcedureName,
    params Object[] parameterValues
)

public:
virtual int ExecuteNonQuery(
    DbTransaction^ transaction, 
    String^ storedProcedureName, 
    ... array<Object^>^ parameterValues
)

public function ExecuteNonQuery(
    transaction : DbTransaction, 
    storedProcedureName : String, 
    ... parameterValues : Object[]
) : int

Parameters

• transaction
  Type: System.Data.Common.DbTransaction

  The IDbTransaction to execute the command within.

• storedProcedureName
  Type: System.String

  The name of the stored procedure to execute.

• parameterValues
  Type: array<System.Object[]

  An array of parameters to pass to the stored procedure. The parameter values must be in call order as they appear in the stored procedure.

Return Value

The number of rows affected.

See Also

Database Class

ExecuteNonQuery Overload

Microsoft.Practices.EnterpriseLibrary.Data Namespace

IDbCommand.ExecuteScalar()