dotnet-sqltest 1.4.4

There is a newer version of this package available.
See the version list below for details.
dotnet tool install --global dotnet-sqltest --version 1.4.4
                    
This package contains a .NET tool you can call from the shell/command line.
dotnet new tool-manifest
                    
if you are setting up this repo
dotnet tool install --local dotnet-sqltest --version 1.4.4
                    
This package contains a .NET tool you can call from the shell/command line.
#tool dotnet:?package=dotnet-sqltest&version=1.4.4
                    
nuke :add-package dotnet-sqltest --version 1.4.4
                    

NuGet Nuget Coverage Status

dotnet-sqltest

Command line tool for running tSQLt unit tests from MSBuild.Sdk.SqlProj projects inside throwaway instances of Docker containers for all compatible SQL Server images.

Usage

Install the tool from the package:

dotnet tool install --global dotnet-sqltest

Update the tool to newer version:

dotnet tool update --global dotnet-sqltest

Invoke the tool:

sqltest runall [options]

Options:
  -i, --image         Docker image
  -p, --project       Database project
  -c, --collation     Server collation
  -r, --result        Save result to JUnit XML file
  --cc-cobertura      Save code coverage to Cobertura XML file
  --cc-disable        Disable code coverage
  --cc-include-tsqlt  Include code coverage of tSQLt schema
  -?, -h, --help      Show help and usage information

Example

Running all tSQLt tests inside throwaway SQL Server container:

sqltest runall --project Database.Tests/Ok --image mcr.microsoft.com/mssql/server

Preparing database... 6 s
Deploying database... 10 s
Running all tests.... 435 ms
Gathering coverage... 1 s
Uncovered statements:
  [dbo].[Example]: SELECT A = 1 INTO #Example
  [dbo].[Example]: UPDATE #Example SET [...]
Failed: 0, Passed: 1, Coverage: 60% (3/5), Duration: 18 s

Build

dotnet-sqltest is build with .NET 8.

Powered by:

Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  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.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

Version Downloads Last Updated
1.4.5 108 10/21/2025
1.4.4 250 8/27/2025
1.4.3 615 1/17/2025
1.4.2 1,284 9/19/2024
1.4.1 536 7/13/2024
1.4.0 530 4/17/2024
1.3.4 737 3/5/2024
1.3.3 476 3/4/2024
1.3.2 3,255 2/27/2024
1.3.1 1,475 12/12/2023
1.3.0 1,707 11/18/2023
1.2.0 8,087 10/16/2023
1.1.1 2,407 9/12/2023
1.1.0 2,462 6/21/2023
1.0.5 2,325 4/4/2023
1.0.4 2,631 4/4/2023
1.0.3 2,475 3/1/2023
1.0.2 3,355 12/11/2022
1.0.1 3,247 11/26/2022
1.0.0 1,800 11/13/2022
0.6.6 2,679 11/13/2022
0.6.5 790 11/11/2022
0.6.4 942 10/14/2022
0.6.3 1,177 8/16/2022
0.6.2 1,307 7/19/2022
0.6.1 1,077 7/6/2022
0.6.0 1,083 6/8/2022
0.5.9 933 6/1/2022
0.5.8 1,063 5/23/2022
0.5.7 912 5/19/2022
0.5.6 934 5/11/2022
0.5.5 942 5/9/2022
0.5.4 899 5/9/2022
0.5.3 1,031 4/29/2022
0.5.2 875 4/29/2022
0.5.1 958 4/28/2022
0.5.0 921 4/26/2022
0.4.1 863 4/23/2022
0.4.0 824 4/22/2022
0.3.0 865 4/15/2022
0.2.0 900 4/13/2022
0.1.0 593 3/5/2022