Export (0) Print
Expand All

SqlDatabaseTestService Class

Provides common functionality that is used by the SqlDatabaseTestClass and methods during test execution.


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

public class SqlDatabaseTestService

The SqlDatabaseTestService type exposes the following members.

Public methodSqlDatabaseTestServiceInitializes a new instance of the SqlDatabaseTestService class.

Public methodDeployDatabaseProject()Deploys the database project by using the settings of the user in the app.config file.
Protected methodStatic memberDeployDatabaseProject(String, String, String, String)Deploys a database project to the database that is specified in the referenced configuration.
Public methodEquals (Inherited from Object.)
Public methodExecuteExecutes the supplied SqlDatabaseTestAction and evaluates the results of the execution by using each TestCondition that is contained in the Conditions collection.
Protected methodFinalize (Inherited from Object.)
Public methodGenerateData()When overridden in a derived class, generates data by using the settings of the user in the app.config file.
Protected methodStatic memberGenerateData(String, Boolean, String, String)When overridden in a derived class, generates data to the specified database by using the referenced data generation plan.
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodOpenExecutionContextOpens the ConnectionContext that will be used for a test execution.
Public methodOpenPrivilegedContextOpens the context that is used when the results of SQL execution are verified and when the database is set up.
Public methodToString (Inherited from Object.)

The services provided by this class include the following:

  • Reading the application configuration to open and supply database connections.

  • Executing the Transact-SQL script.

  • Evaluating test conditions.

  • Deploying database projects that are based on application configuration.

  • Generating data by using a data generator configuration.

To provide your own custom SqlDatabaseTestService implementation, override methods in this class. This is the primary mechanism for modifying how tests are executed, how test conditions are evaluated, and how connections are created while still working in the context of the Database Unit Test Designer.

When you create your implementation, it must be registered by using the TestService. If you want to open an execution context and you do not want to use impersonation, also implement your own ConnectionContext.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
© 2014 Microsoft