SqlCommandBuilder 1.0.0-alpha

.NET 6.0 This package targets .NET 6.0. The package is compatible with this framework or higher.
This is a prerelease version of SqlCommandBuilder. 
dotnet add package SqlCommandBuilder --version 1.0.0-alpha
                    


                    

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


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="SqlCommandBuilder" />
                    


                            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 SqlCommandBuilder --version 1.0.0-alpha
                    


                    

                
#r "nuget: SqlCommandBuilder, 1.0.0-alpha"
#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. 
#:package SqlCommandBuilder@1.0.0-alpha
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=SqlCommandBuilder&version=1.0.0-alpha&prerelease
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=SqlCommandBuilder&version=1.0.0-alpha&prerelease
                    


                            Install as a Cake Tool

SqlCommandBuilder

A library for building raw SQL queries more maintainably and with fewer mistakes.

Prequisite

None to be prepared

How to use

Introduction

  • You can start querying by call CommandBuilder.Init(). Then write your query as your needs.
  • You can use some method to construct your query and at the end call .Build()
  • .Build() have return of IQueryCommandResult, which have two properties Script and Parameters
  • Script is raw sql query
  • Parameters is sets of name and value bind parameters to query.

SELECT

  • Select(string tableName, string[] columns) used to construct initial statement as select statement with initial columns to select
  • Select(string[] columns) used to add additional field to select within statement

Example

CommandBuilder.Init().Select("category", new string[] { "name", "category_id" }).Build()

This will produce raw query

SELECT name, category_id FROM category

INSERT

You can construct insert statement and specify sets of column and value to insert to specific table

CommandBuilder.Init().Insert("category", new Dictionary<string, object?>()
{
{ "name", "Karya Ilmiah" }
}).Build();

This will produce raw query

INSERT INTO category(name) VALUES(@name)

And the binding parameters will available in IQueryCommandResult.Parameters that contains key value pair of @name dan Karya Ilmiah

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.0.0-alpha 119 3/5/2024