SqlScriptRunner 1.0.0

There is a newer version of this package available.
See the version list below for details.

dotnet add package SqlScriptRunner --version 1.0.0

NuGet\Install-Package SqlScriptRunner -Version 1.0.0

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="SqlScriptRunner" Version="1.0.0" />

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

paket add SqlScriptRunner --version 1.0.0

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

#r "nuget: SqlScriptRunner, 1.0.0"

#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 SqlScriptRunner as a Cake Addin
#addin nuget:?package=SqlScriptRunner&version=1.0.0

// Install SqlScriptRunner as a Cake Tool
#tool nuget:?package=SqlScriptRunner&version=1.0.0

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

SQL SCRIPT RUNNER

SQL script runner is a package, wich run script from concrete folder and subfolder. You can use it when you have database firs project and before start server you want to update your database.

Setup model fields

ConnectionString: Connection string to database,
FolderPath: Path to root folder with sql script
DeployScriptsTableName: Name of table where will be keep all deployed scripts
DataBaseType: Typeof database (Postgresql, Mssql, Mysql)
InitFolderPath: Path to folder with init scripts (like create database or create schema)

Example of use

var scriptRunner = SqlScriptRunner.GetScriptRunner(new SetupModel
{
    ConnectionString = "Server=localhost; Database=tests; User Id=sa; Password=pa55w0rd!;TrustServerCertificate=true",
    FolderPath = "/mssql/scripts",
    InitFolderPath = "/mssql/scripts/init",
    DataBaseType = DataBaseTypeEnum.Mssql
}).RunDeploy();

This example will be run all scripts (*.sql file) from folder /mssql/scripts folder and subfolders

Product	Compatible and additional computed target framework versions.
.NET	net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed.

Product

.NET

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

net6.0
- Microsoft.Data.SqlClient (>= 5.0.0)
- MySqlConnector (>= 2.1.13)
- Npgsql (>= 6.0.6)

NuGet packages (3)

Showing the top 3 NuGet packages that depend on SqlScriptRunner:

Package	Downloads
SqlScriptRunner.PostgreSQL Package Description	417
SqlScriptRunner.MySql Package Description	416
SqlScriptRunner.MSSql Package Description	384

GitHub repositories

This package is not used by any popular GitHub repositories.