sqlize 0.2.0
dotnet add package sqlize --version 0.2.0
NuGet\Install-Package sqlize -Version 0.2.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="sqlize" Version="0.2.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="sqlize" Version="0.2.0" />
<PackageReference Include="sqlize" />
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 sqlize --version 0.2.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: sqlize, 0.2.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.
#:package sqlize@0.2.0
#: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=sqlize&version=0.2.0
#tool nuget:?package=sqlize&version=0.2.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
sqlize
An easy-to-use .NET 6+ library for generating formatted SQL code from an interpolated string.
Usage
class Blog
{
public int Id { get; set; }
public string Name { get; set; }
}
var id = 123;
var sqlize = new Sqlize();
// Declare entities for use
sqlize.Declare<Blog>(out var b);
// Generate formated SQL
var query = sqlize.ToFormattableString($@"
SELECT {b.Name}
FROM {b}
WHERE {b.Id} = {id};
");
Console.WriteLine(query);
// SELECT b.Name
// FROM Blog AS b
// WHERE b.Id = 123;
Options
var query = sqlize.ToFormattableString($@"
SELECT {b.Name}
FROM {b}
WHERE {b.Id} = {id};
", options => {
options.PropertyNameFormat = propertyName => $"\"{propertyName}\"";
options.TableNameFormat = tableName => $"\"{tableName}\"";
options.IsAliasEnabled = true;
});
Console.WriteLine(query);
// SELECT b."Name"
// FROM "Blog" AS b
// WHERE b."Id" = 123;
| Option | Description |
|---|---|
| PropertyNameFormat | Method used to format properties name in query |
| TableNameFormat | Method used to format tables name in query |
| IsAliasEnabled | Is SQL alias must be generated by sqlize ? True by default |
| Product | Versions 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.