sqlize 0.1.0

.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 sqlize --version 0.1.0
                    


                    

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


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="sqlize" />
                    


                            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 sqlize --version 0.1.0
                    


                    

                
#r "nuget: sqlize, 0.1.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.1.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.1.0
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=sqlize&version=0.1.0
                    


                            Install as a Cake Tool

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.ToFormattedSql($@"
    SELECT {b.Name}
    FROM {b}
    WHERE {b.Id} = {id};
");

Console.WriteLine(query);

//  SELECT b.Name
//  FROM Blog AS b
//  WHERE b.Id = 123;

SQL Injection

You can use the ToFormattableString function instead of ToFormattedSql to obtain a FormattableString and thus use the SQL injection-proof methods of your favorite ORMs.

FormattableString query = sqlize.ToFormattableString($@"SELECT {b.Name} FROM {b} WHERE {b.Id} = {id};");

Options

This first version offers few options for managing the specific features of dbms and users.

<table> <tr> <td>Option</td> <td>Description</td> <td>Example</td> </tr> <tr> <td><pre lang="C#">SqlizeFlags.DoubleQuotedName<pre></td> <td>Encloses column and table names in double quotes</td> <td> <pre lang="c#"> sqlize.ToFormattedSql($"SELECT {b.Name}", SqlizeFlags.DoubleQuotedName); // SELECT b."Name" </pre> </td> </tr> </table>

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
0.2.0 271 12/27/2023
0.1.0 282 10/24/2023