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" />
paket add SqExpress --version 0.0.5
- “Where” now accepts nulls
- Database name can be specified in table names
- Temp Tables
- Top -> Limit in PostgresSQL
- Export/Import to/from PlainList
- Export/Import to/from Xml
- Custom scalar functions
- SqlBuilderBase is now internal
- IExprVistor changed
- No dependencies.
This package is not used by any NuGet packages.
This package is not used by any popular GitHub repositories.