SqlDatabaseTestService.Execute Method (ConnectionContext, ConnectionContext, SqlDatabaseTestAction, DbParameter )

Executes the supplied SqlDatabaseTestAction and evaluates the results of the execution by using each TestCondition that is contained in the Conditions collection.

Namespace:   Microsoft.Data.Tools.Schema.Sql.UnitTesting
Assembly:  Microsoft.Data.Tools.Schema.Sql.UnitTesting (in Microsoft.Data.Tools.Schema.Sql.UnitTesting.dll)

Syntax

public virtual SqlExecutionResult[] Execute(
    ConnectionContext scriptExecutionContext,
    ConnectionContext privilegedExecutionContext,
    SqlDatabaseTestAction action,
    params DbParameter[] sqlParameters
)

public:
virtual array<SqlExecutionResult^>^ Execute(
    ConnectionContext^ scriptExecutionContext,
    ConnectionContext^ privilegedExecutionContext,
    SqlDatabaseTestAction^ action,
    ... array<DbParameter^>^ sqlParameters
)

abstract Execute : 
        scriptExecutionContext:ConnectionContext *
        privilegedExecutionContext:ConnectionContext *
        action:SqlDatabaseTestAction *
        [<ParamArrayAttribute>] sqlParameters:DbParameter[] -> SqlExecutionResult[]
override Execute : 
        scriptExecutionContext:ConnectionContext *
        privilegedExecutionContext:ConnectionContext *
        action:SqlDatabaseTestAction *
        [<ParamArrayAttribute>] sqlParameters:DbParameter[] -> SqlExecutionResult[]

Public Overridable Function Execute (
    scriptExecutionContext As ConnectionContext,
    privilegedExecutionContext As ConnectionContext,
    action As SqlDatabaseTestAction,
    ParamArray sqlParameters As DbParameter()
) As SqlExecutionResult()

Parameters

• scriptExecutionContext
  Type: Microsoft.Data.Tools.Schema.Sql.UnitTesting.ConnectionContext

  The context to use when the Transact-SQL is executed in the SqlScript.

• privilegedExecutionContext
  Type: Microsoft.Data.Tools.Schema.Sql.UnitTesting.ConnectionContext

  The context to use when the test conditions are validated.

• action
  Type: Microsoft.Data.Tools.Schema.Sql.UnitTesting.SqlDatabaseTestAction

  The SqlDatabaseTestAction to execute.

• sqlParameters
  Type: System.Data.Common.DbParameter[]

  Zero or more DbParameter that will be provided in the executed Transact-SQL.

Return Value

Type: Microsoft.Data.Tools.Schema.Sql.UnitTesting.SqlExecutionResult[]

An array of SqlExecutionResult objects.

See Also

SqlScript
SqlDatabaseTestAction
DbParameter
SqlExecutionResult
SqlDatabaseTestService Class
Microsoft.Data.Tools.Schema.Sql.UnitTesting Namespace

Return to top