Microsoft.SqlServer.Scripting 11.0.2100.61

.NET Framework

dotnet add package Microsoft.SqlServer.Scripting --version 11.0.2100.61

NuGet\Install-Package Microsoft.SqlServer.Scripting -Version 11.0.2100.61

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="Microsoft.SqlServer.Scripting" Version="11.0.2100.61" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add Microsoft.SqlServer.Scripting --version 11.0.2100.61

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: Microsoft.SqlServer.Scripting, 11.0.2100.61"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

// Install Microsoft.SqlServer.Scripting as a Cake Addin
#addin nuget:?package=Microsoft.SqlServer.Scripting&version=11.0.2100.61

// Install Microsoft.SqlServer.Scripting as a Cake Tool
#tool nuget:?package=Microsoft.SqlServer.Scripting&version=11.0.2100.61

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Contains the necessary SMO dependencies to allow execution of full client-side SQL scripts (eg. containing the GO command) to be executed from .NET.

Such scripts can be executed from within Management Studio but will fail when executed through ADO.NET. This package contains the dependencies to allow that to happen.

Example usage:

public static void ExecuteSqlScript(SqlConnection conn, string script)
{
  var serverConnection = new Microsoft.SqlServer.Management.Common.ServerConnection(conn);
  var server = new Microsoft.SqlServer.Management.Smo.Server(serverConnection);
  server.ConnectionContext.ExecuteNonQuery(script);
}

PS. Anyone can download Sql Server Express (for free!) and copy these assemblies from the installation folder, but having a simple package just saves so much pain.

Product	Compatible and additional computed target framework versions.
.NET Framework	net is compatible.

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

GitHub repositories (1)

Showing the top 1 popular GitHub repositories that depend on Microsoft.SqlServer.Scripting:

Repository	Stars
smartstore/SmartStoreNET Open Source ASP.NET MVC Enterprise eCommerce Shopping Cart Solution	2.6K

Version	Downloads	Last updated
11.0.2100.61	14,778	9/11/2012