Microsoft.SqlServer.Scripting 11.0.2100.61

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
#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

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.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on Microsoft.SqlServer.Scripting:

Package Downloads
BLocal

The conventional ways oftenfail to suit the needs required for proper localization. BLocal provides a framework for building a clean localization mechanism, together with some powerful standard implementations. Source code and documentation (wiki) available on https://github.com/BackseatDevelopers/BLocal Find BLocal.Web on NuGet Find BLocal.Web.Manager (free management tool) on github

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
Version Downloads Last updated
11.0.2100.61 1,344,990 9/11/2012