SqlDatabaseTestService Class

Article
11/05/2015

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)

Inheritance Hierarchy

System.Object
Microsoft.Data.Tools.Schema.Sql.UnitTesting.SqlDatabaseTestService

Syntax

public class SqlDatabaseTestService

public ref class SqlDatabaseTestService

type SqlDatabaseTestService = class end

Public Class SqlDatabaseTestService

Constructors

	Name	Description
	SqlDatabaseTestService()	Initializes a new instance of the SqlDatabaseTestService class.

Methods

	Name	Description
	DeployDatabaseProject()	Deploys the database project by using the settings of the user in the app.config file.
	DeployDatabaseProject(String, String, String, String)	Deploys a database project to the database that is specified in the referenced configuration.
	Equals(Object)	(Inherited from Object.)
	Execute(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.
	Finalize()	(Inherited from Object.)
	GenerateData()	When overridden in a derived class, generates data by using the settings of the user in the app.config file.
	GetHashCode()	(Inherited from Object.)
	GetType()	(Inherited from Object.)
	MemberwiseClone()	(Inherited from Object.)
	OpenExecutionContext()	Opens the ConnectionContext that will be used for a test execution.
	OpenPrivilegedContext()	Opens the context that is used when the results of SQL execution are verified and when the database is set up.
	ToString()	(Inherited from Object.)

Remarks

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.

Thread Safety

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

Share via