GennadyGS.SqlQueryBuilder 1.0.2

.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 GennadyGS.SqlQueryBuilder --version 1.0.2
                    


                    

                
NuGet\Install-Package GennadyGS.SqlQueryBuilder -Version 1.0.2
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="GennadyGS.SqlQueryBuilder" Version="1.0.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="GennadyGS.SqlQueryBuilder" Version="1.0.2" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="GennadyGS.SqlQueryBuilder" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add GennadyGS.SqlQueryBuilder --version 1.0.2
                    


                    

                
#r "nuget: GennadyGS.SqlQueryBuilder, 1.0.2"
#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. 
#addin nuget:?package=GennadyGS.SqlQueryBuilder&version=1.0.2
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=GennadyGS.SqlQueryBuilder&version=1.0.2
                    


                            Install as a Cake Tool

SqlQueryBuilder

Utility class for building SQL queries with parameters based on C# string interpolation.

Examples

// Building SQL query with parameters
SqlQueryBuilder queryBuilder = $"SELECT * FROM Orders WHERE Id = {123}";

Assert.Equal(
    "SELECT * FROM Orders WHERE Id = @p1", 
    queryBuilder.GetQuery());
Assert.Equal(
    new Dictionary<string, object?> { ["p1"] = 123 }, 
    queryBuilder.GetParameters());

// Composing SQL queries with parameters
SqlQueryBuilder innerQueryBuilder = $"SELECT * FROM Orders WHERE Id = {123}";
SqlQueryBuilder outerQueryBuilder = 
    $"SELECT * FROM ({innerQueryBuilder}) src WHERE IsValid = {true}";

Assert.Equal(
    "SELECT * FROM (SELECT * FROM Orders WHERE Id = @p1) src WHERE IsValid = @p2",
    outerQueryBuilder.GetQuery());
Assert.Equal(
    new Dictionary<string, object?> { ["p1"] = 123, ["p2"] = true }, 
    outerQueryBuilder.GetParameters());

// Building SQL query with specified parameter name prefix
SqlQueryBuilder queryBuilder = $"SELECT * FROM Orders WHERE Id = {123}";

var (query, parameters) = queryBuilder.GetQueryAndParameters("param");

Assert.Equal("SELECT * FROM Orders WHERE Id = @param1", query);
Assert.Equal(new Dictionary<string, object?> { ["param1"] = 123 }, parameters);
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.  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.

  • net6.0

    • No dependencies.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
1.4.1 262 12/9/2023
1.4.0 141 12/9/2023
1.3.1 242 4/29/2023
1.2.2 385 11/9/2022
1.2.1 540 8/4/2022
1.1.1 449 8/2/2022
1.0.5 452 8/1/2022
1.0.4 467 3/26/2022
1.0.3 480 2/7/2022
1.0.2 494 1/22/2022
1.0.1 505 1/16/2022
1.0.0 528 1/15/2022