WarehouseDataAccessComponent.ExecuteNonQuery Method

Executes the SQL command and does not produce a result set.

Namespace:  Microsoft.TeamFoundation.Warehouse
Assembly:  Microsoft.TeamFoundation.Warehouse (in Microsoft.TeamFoundation.Warehouse.dll)

Syntax

'Declaration
Public Overridable Function ExecuteNonQuery ( _
    commandType As CommandType, _
    sqlStatement As String, _
    parameters As IEnumerable(Of SqlParameter) _
) As Integer

public virtual int ExecuteNonQuery(
    CommandType commandType,
    string sqlStatement,
    IEnumerable<SqlParameter> parameters
)

public:
virtual int ExecuteNonQuery(
    CommandType commandType, 
    String^ sqlStatement, 
    IEnumerable<SqlParameter^>^ parameters
)

abstract ExecuteNonQuery : 
        commandType:CommandType * 
        sqlStatement:string * 
        parameters:IEnumerable<SqlParameter> -> int  
override ExecuteNonQuery : 
        commandType:CommandType * 
        sqlStatement:string * 
        parameters:IEnumerable<SqlParameter> -> int

public function ExecuteNonQuery(
    commandType : CommandType, 
    sqlStatement : String, 
    parameters : IEnumerable<SqlParameter>
) : int

Parameters

• commandType
  Type: System.Data.CommandType

  Command type. Only Text and StoredProcedure are supported.

• sqlStatement
  Type: System.String

  SQL statement to execute.

• parameters
  Type: System.Collections.Generic.IEnumerable<SqlParameter>

  SQL parameters. May be null. Only Input and Output parameters are supported.

Return Value

Type: System.Int32
Row count for the query.

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

WarehouseDataAccessComponent Class

Microsoft.TeamFoundation.Warehouse Namespace