SlimQuery 1.0.3
dotnet add package SlimQuery --version 1.0.3
NuGet\Install-Package SlimQuery -Version 1.0.3
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="SlimQuery" Version="1.0.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="SlimQuery" Version="1.0.3" />
<PackageReference Include="SlimQuery" />
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 SlimQuery --version 1.0.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: SlimQuery, 1.0.3"
#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 SlimQuery@1.0.3
#: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=SlimQuery&version=1.0.3
#tool nuget:?package=SlimQuery&version=1.0.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
SlimQuery
A high-performance micro ORM for .NET 10 that combines Dapper's speed with EF Core-like ergonomics.
Features
- Fast Performance - Built on Dapper, the fastest .NET ORM
- No Attributes Required - Plain POCOs, no decorations needed
- Multi-Database Support - SQLite, PostgreSQL, SQL Server, MySQL
- Fluent Query Builder - Chainable LINQ-like syntax
- Pagination - Built-in paging with metadata
- Relations - HasOne, HasMany with batched loading (no N+1)
- Bulk Operations - Efficient batch inserts/updates/deletes
- Transactions - Full ACID support with savepoints
- Caching - Query result caching with tag-based invalidation
- Migrations - Built-in migration system
- Dependency Injection - Microsoft.Extensions.DependencyInjection integration
Quick Start
using SlimQuery.Core;
using Microsoft.Data.Sqlite;
// Create connection
using var connection = new SqliteConnection("Data Source=mydb.sqlite");
await connection.OpenAsync();
// Wrap with SlimQuery
var db = new SlimQuery.Core.SlimConnection(connection);
// Query
var users = await db.QueryAsync<User>("SELECT * FROM users WHERE active = @Active", new { Active = true });
// CRUD
var user = await db.GetByIdAsync<User>(1);
var id = await db.InsertAsync(new User { Name = "John" });
await db.UpdateAsync(user);
await db.DeleteAsync<User>(1);
// Fluent Query Builder
var users = await db.From<User>()
.Where(x => x.Active == true)
.OrderBy(x => x.Name)
.Skip(0).Take(10)
.ToListAsync();
// Pagination
var paged = await db.From<User>()
.Where(x => x.Active == true)
.PaginateAsync(page: 1, pageSize: 20);
Installation
dotnet add package SlimQuery
Supported Databases
- SQLite (Microsoft.Data.Sqlite)
- PostgreSQL (Npgsql)
- SQL Server (Microsoft.Data.SqlClient)
- MySQL (MySqlConnector)
Project Structure
src/SlimQuery/
├── Core/ # ISlimConnection, SlimConnection, SlimTransaction
├── Mapping/ # ObjectMapper, MapperCache, TypeConverters
├── Query/ # QueryBuilder, ExpressionExtractor
│ └── SqlDialect/ # Database-specific SQL generation
├── Relations/ # RelationConfig, RelationLoader
├── Bulk/ # BulkOperations
├── Cache/ # QueryCache
├── Migrations/ # MigrationManager
├── Extensions/ # DI extensions, Pagination
License
MIT
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | 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. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net10.0
- Azure.Identity (>= 1.13.1)
- Dapper (>= 2.1.35)
- Microsoft.Data.SqlClient (>= 5.2.2)
- Microsoft.Data.Sqlite (>= 10.0.0)
- Microsoft.Extensions.Caching.Memory (>= 10.0.0)
- Microsoft.Extensions.DependencyInjection (>= 10.0.0)
- Microsoft.Extensions.Hosting.Abstractions (>= 10.0.0)
- Microsoft.Identity.Client (>= 4.66.1)
- MySqlConnector (>= 2.4.0)
- Npgsql (>= 9.0.2)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.