SqExpress 0.0.5

SqExpress is a sql query builder which allows creating SQL expression in C# code with strong typing and intellisense (without LINQ!).
The library provides a generic sql syntax tree with exports to MS t-SQL and Postgres SQL text.
It also provides a set of builders and operators which will help you building complex Sql expressions.
It does not use Linq and your C# code will be close to real SQL as much as possible, so it can be used when you need the full SQL flexibility to create efficient Db requests.
It is delivered with a simple but efficient data access mechanism which warps ADO.Net DbConnection and can be used with MS SQL Client or Npgsql.
It can be used together with the “Code First” concept when you declare SQL tables as C# classes with possibility to generate recreation scripts for a target platform (MS SQL or Postgres SQL)

Install-Package SqExpress -Version 0.0.5
dotnet add package SqExpress --version 0.0.5
<PackageReference Include="SqExpress" Version="0.0.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SqExpress --version 0.0.5
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

New Features
- “Where” now accepts nulls
- expr.SyntaxTree().WalkThrough()
- expr.SyntaxTree().Find()
- expr.SyntaxTree().Modify
- ExprDeserializer.Deserialize()
- Database name can be specified in table names
- Temp Tables
- Top -> Limit in PostgresSQL
- DateAdd
- Export/Import to/from PlainList
- Export/Import to/from Xml
- Custom scalar functions
Braking Changes:
- SqlBuilderBase is now internal
- IExprVistor changed

  • .NETStandard 2.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 History

Version Downloads Last updated
0.0.5 59 10/20/2020
0.0.3.1 86 10/14/2020