FlexQuery.NET.Dapper
4.0.0-rc.2
See the version list below for details.
dotnet add package FlexQuery.NET.Dapper --version 4.0.0-rc.2
NuGet\Install-Package FlexQuery.NET.Dapper -Version 4.0.0-rc.2
<PackageReference Include="FlexQuery.NET.Dapper" Version="4.0.0-rc.2" />
<PackageVersion Include="FlexQuery.NET.Dapper" Version="4.0.0-rc.2" />
<PackageReference Include="FlexQuery.NET.Dapper" />
paket add FlexQuery.NET.Dapper --version 4.0.0-rc.2
#r "nuget: FlexQuery.NET.Dapper, 4.0.0-rc.2"
#:package FlexQuery.NET.Dapper@4.0.0-rc.2
#addin nuget:?package=FlexQuery.NET.Dapper&version=4.0.0-rc.2&prerelease
#tool nuget:?package=FlexQuery.NET.Dapper&version=4.0.0-rc.2&prerelease
FlexQuery.NET.Dapper
SQL generation and async execution for Dapper.
When to Use This Package
Install this package when your application uses Dapper instead of Entity Framework Core. FlexQuery.NET.Dapper translates QueryOptions into parameterized, dialect-aware SQL and executes it directly via DbConnection.
Installation
dotnet add package FlexQuery.NET.Dapper
Registration
The SQL dialect is auto-detected from the DbConnection at runtime — no manual dialect configuration is required. Register your entity mapping model once at startup:
using FlexQuery.NET.Dapper.Configuration;
FlexQueryDapper.Configure(options =>
{
options.Model.Entity<User>(entity =>
{
entity.ToTable("Users");
});
options.CommandTimeout = 60;
});
Or configure options per query:
options.CommandTimeout = 60;
Quick Start
using FlexQuery.NET.Models;
[HttpGet("users")]
public async Task<IActionResult> GetUsers([FromQuery] FlexQueryParameters parameters)
{
await using var connection = new SqlConnection(connectionString);
var result = await connection.FlexQueryAsync<User>(parameters, options =>
{
options.AllowedFields = new HashSet<string> { "Id", "Name", "Email" };
}, cancellationToken: cancellationToken);
return Ok(result);
}
Features
- SQL Generation —
SqlTranslatorproduces parameterized, injection-safe SQL - Dialect Support — SQL Server, PostgreSQL, MySQL, MariaDB, SQLite, and Oracle, auto-detected from the connection
- Flat Projection — Deep select paths (e.g.,
Orders.Total) becomeLEFT JOINwith flattened aliases - Entity Mapping — Fluent entity-to-table mapping via
ModelBuilderandIEntityTypeConfiguration<T> - Filtered Includes — Related collections hydrated from the include tree
- SQL Execution Logging — Execution logs include copy-paste-ready
DECLAREscripts - Typed DTO Results —
FlexQueryAsync<TEntity, TResponse>overloads for strongly-typed responses - Diagnostics — Pass a listener via the options to observe pipeline stages
Known Limitations
- Some aggregate functions may vary by dialect
Related Packages
- FlexQuery.NET — Core query engine
- FlexQuery.NET.AspNetCore — ASP.NET Core integration
- FlexQuery.NET.EntityFrameworkCore — Alternative provider for EF Core
Documentation
| 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 is compatible. 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 is compatible. 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. |
-
net10.0
- Dapper (>= 2.1.72)
- FlexQuery.NET (>= 4.0.0-rc.2)
- Microsoft.Extensions.Logging.Abstractions (>= 10.0.0)
- Microsoft.Extensions.Primitives (>= 10.0.0)
-
net6.0
- Dapper (>= 2.1.72)
- FlexQuery.NET (>= 4.0.0-rc.2)
- Microsoft.Extensions.Logging.Abstractions (>= 6.0.4)
- Microsoft.Extensions.Primitives (>= 6.0.0)
-
net8.0
- Dapper (>= 2.1.72)
- FlexQuery.NET (>= 4.0.0-rc.2)
- Microsoft.Extensions.Logging.Abstractions (>= 8.0.2)
- Microsoft.Extensions.Primitives (>= 8.0.0)
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 |
|---|---|---|
| 4.0.0 | 136 | 9/23/2026 |
| 4.0.0-rc.3 | 73 | 9/22/2026 |
| 4.0.0-rc.2 | 79 | 9/17/2026 |
| 4.0.0-rc.1 | 104 | 9/10/2026 |
| 4.0.0-preview.3 | 84 | 7/18/2026 |
| 4.0.0-preview.2 | 81 | 7/14/2026 |
| 4.0.0-preview.1 | 85 | 7/12/2026 |
| 4.0.0-beta1.0 | 85 | 9/8/2026 |
| 3.1.1 | 155 | 7/4/2026 |
| 3.1.0 | 150 | 6/26/2026 |
| 3.0.6 | 139 | 6/24/2026 |
| 3.0.5 | 137 | 6/24/2026 |
| 3.0.4 | 141 | 6/23/2026 |
| 3.0.3 | 137 | 6/23/2026 |
| 3.0.2 | 138 | 6/22/2026 |
| 3.0.1 | 142 | 6/22/2026 |
- docs(changelog): add the v4.0.0 release notes
- docs(readme): describe include relationship query blocks
- feat(samples): demo include relationship blocks in the sample playground
- chore(docs-v4): publish the legacy VitePress v3 site under /v3
- docs(v4-site): rewrite the expand guide as include relationship query blocks
- test(providers): align EF Core and Dapper suites with include blocks
- docs(openapi): document include relationship blocks
- refactor(dapper): generate include-block SQL from the unified include tree
- refactor(efcore): build include chains from the unified include tree
- refactor(parsers): parse include relationship blocks in FQL and reject expand
- refactor(core): unify relationship inclusion under the include tree