ExecuteDDL Class

MSBuild

previous page next page

MSBuild task to execute DDL and SQL statements.

Namespace: MSBuild.Community.Tasks.SqlServer
Assembly: MSBuild.Community.Tasks (in MSBuild.Community.Tasks.dll)

Syntax

Visual Basic (Declaration)
Public Class ExecuteDDL Inherits Task

C#
public class ExecuteDDL : Task

C++
ref class ExecuteDDL : Task

J#
public class ExecuteDDL extends Task

JScript
public class ExecuteDDL extends Task

Example

	Copy Code
<PropertyGroup> <ConnectionString>Server=localhost;Integrated Security=True</ConnectionString> </PropertyGroup> <Target Name="ExecuteDDL"> <ExecuteDDL ConnectionString="$(ConnectionString)" Files="SqlBatchScript.sql" ContinueOnError="false" /> </Target>

Copy Code

             <PropertyGroup>
                    <ConnectionString>Server=localhost;Integrated Security=True</ConnectionString>
                </PropertyGroup>
            
             <Target Name="ExecuteDDL">
                    <ExecuteDDL ConnectionString="$(ConnectionString)" Files="SqlBatchScript.sql" ContinueOnError="false" />
             </Target>

Remarks

Requires the the SQL Server libraries and dynamically loads the required Microsoft.SqlServer.ConnectionInfo assembly.

Inheritance Hierarchy

System.Object
Microsoft.Build.Utilities.Task
MSBuild.Community.Tasks.SqlServer.ExecuteDDL

Thread Safety

Public static (Shared in Visual Basic)staticShared members of this type are safe for multithreaded operations. Instance members are not guaranteed to be thread-safe.