Microsoft.SqlServer.Scripting 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.

Install-Package Microsoft.SqlServer.Scripting -Version 11.0.2100.61
dotnet add package Microsoft.SqlServer.Scripting --version 11.0.2100.61
<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, C# scripting and .NET Interactive. 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.

Dependencies

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 History

Version Downloads Last updated
11.0.2100.61 491,780 9/11/2012