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.

Dependencies

This package has no dependencies.

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

Repository Stars
smartstore/SmartStoreNET
Open Source ASP.NET MVC Ecommerce Shopping Cart Solution

Version History

Version Downloads Last updated
11.0.2100.61 275,067 9/11/2012