SqlScriptRunner.Abstraction 1.0.0

.NET 6.0 This package targets .NET 6.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package SqlScriptRunner.Abstraction --version 1.0.0                

                    
                

            
NuGet\Install-Package SqlScriptRunner.Abstraction -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.Abstraction" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add SqlScriptRunner.Abstraction --version 1.0.0                

                    
                

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

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

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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on SqlScriptRunner.Abstraction:

Package Downloads
SqlScriptRunner

Package Description

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
2.0.2 458 4/1/2023
2.0.1 205 4/1/2023
2.0.0 373 4/1/2023
1.0.0 200 4/1/2023