![]() |
VOOZH | about |
dotnet add package KnightMoves.SqlObjects --version 1.3.0
NuGet\Install-Package KnightMoves.SqlObjects -Version 1.3.0
<PackageReference Include="KnightMoves.SqlObjects" Version="1.3.0" />
<PackageVersion Include="KnightMoves.SqlObjects" Version="1.3.0" />Directory.Packages.props
<PackageReference Include="KnightMoves.SqlObjects" />Project file
paket add KnightMoves.SqlObjects --version 1.3.0
#r "nuget: KnightMoves.SqlObjects, 1.3.0"
#:package KnightMoves.SqlObjects@1.3.0
#addin nuget:?package=KnightMoves.SqlObjects&version=1.3.0Install as a Cake Addin
#tool nuget:?package=KnightMoves.SqlObjects&version=1.3.0Install as a Cake Tool
A C# wrapper to the SQL language for creating SQL code in .NET projects for use with ADO, Dapper, or other ORMs
https://docs.knightmovesolutions.com/sql-objects/index.html
Install the NuGet package
PS c:\> Install-Package KnightMoves.SqlObjects
Import the namespace
using KnightMoves.SqlObjects;
Use the Fluent API through the static TSQL class
var sql = TSQL
.SELECT()
.STAR()
.FROM("Products")
.Build()
;
Console.WriteLine(sql);
Output:
SELECT
*
FROM [Products]
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net6.0 net6.0 is compatible. net6.0-android net6.0-android was computed. net6.0-ios net6.0-ios was computed. net6.0-maccatalyst net6.0-maccatalyst was computed. net6.0-macos net6.0-macos was computed. net6.0-tvos net6.0-tvos was computed. net6.0-windows net6.0-windows was computed. net7.0 net7.0 is compatible. net7.0-android net7.0-android was computed. net7.0-ios net7.0-ios was computed. net7.0-maccatalyst net7.0-maccatalyst was computed. net7.0-macos net7.0-macos was computed. net7.0-tvos net7.0-tvos was computed. net7.0-windows net7.0-windows was computed. net8.0 net8.0 is compatible. net8.0-android net8.0-android was computed. net8.0-browser net8.0-browser was computed. net8.0-ios net8.0-ios was computed. net8.0-maccatalyst net8.0-maccatalyst was computed. net8.0-macos net8.0-macos was computed. net8.0-tvos net8.0-tvos was computed. net8.0-windows net8.0-windows was computed. net9.0 net9.0 was computed. net9.0-android net9.0-android was computed. net9.0-browser net9.0-browser was computed. net9.0-ios net9.0-ios was computed. net9.0-maccatalyst net9.0-maccatalyst was computed. net9.0-macos net9.0-macos was computed. net9.0-tvos net9.0-tvos was computed. net9.0-windows net9.0-windows was computed. net10.0 net10.0 was computed. net10.0-android net10.0-android was computed. net10.0-browser net10.0-browser was computed. net10.0-ios net10.0-ios was computed. net10.0-maccatalyst net10.0-maccatalyst was computed. net10.0-macos net10.0-macos was computed. net10.0-tvos net10.0-tvos was computed. net10.0-windows net10.0-windows was computed. |
Showing the top 1 NuGet packages that depend on KnightMoves.SqlObjects:
| Package | Downloads |
|---|---|
|
KnightMoves.SqlOjbects.ForSqlServer
This package retrieves SQL Server database metadata and registers the metadata with IServiceCollection so the metadata can be injected into data access layer objects for dynamic query building |
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last Updated | |
|---|---|---|---|
| 1.3.0 | 171 | 9/13/2025 | |
| 1.2.0 | 231 | 9/9/2025 | 1.2.0 is deprecated because it has critical bugs. |
| 1.1.0 | 257 | 9/4/2025 | 1.1.0 is deprecated because it has critical bugs. |
| 1.0.0 | 229 | 1/27/2025 | 1.0.0 is deprecated because it has critical bugs. |
It was discovered that the package was launched as v1.0.0 based on the wrong commit due to a major merge blunder. Previous versions are broken. This is the actual first stable release.