Query models for building and representing queries - QueryNode, QueryRequest, ConditionNode, SortBy, builders. Shared by Lyo.Query and Lyo.Api.
Dynamic Linq Query Builder base on Expressions (core). Excellent PrepareQuery method with QueryParams
dotFramework Dynamic Query Builder for Oracle
Fluent T-SQL Query Builder for PostgreSQL
Fluent T-SQL Query Builder for MySQL
DotnetStandardQueryBuilder.OData package contains methods to build query request from http request query string
Dependency injection builder extensions for the softaware.CQS.Decorators.ApplicationInsights package.
SharePoint CAML query builder - Build CAML queries using Lambda Expression with simple POCOs.
A C# library which helps create customized and extensible LINQ-like sql queries more easily.
Server-side .NET query builder for JavaScript data tables (base package)
Provides a fluent LINQ type query builder for building Gremlin queries.
The Dapper SqlBuilder component, for building SQL queries dynamically.
Modular RAG pipeline library for .NET — ingestion and retrieval pipeline builders, self-query, corrective RAG and conversation memory
FluentData.Core is a Micro ORM that makes it simple to select, insert, update and delete data in a database. It gives the developer the power of ADO.NET but with the convenience of an ORM. It has a simple to use fluent API that uses SQL - the best and most suitable language to query data, and SQL or fluent builders to insert, update and delete data.
Elasticsearch client, strongly typed interface to Elasticsearch. Fluent request builder, mapped responses and powerful query dsl. Uses and exposes Elasticsearch.Net
The Dapper SqlBuilder component, for building SQL queries dynamically.
Indexed collection like usual List<T>, but with less allocations. Enables reusing instances of inner array via ArrayPool<T>.Shared. Provides ToRist() extension method which perfectly replaces conventional ToList() for materializing LINQ queries. MoveToArray() method releases ownership of internal buffer, so can be used as “array builder”.
Query Builder for Entity Framework. Supports Filter, Sort and Pagination
SQL provider implementations for OmniDataAccess (PostgreSQL, CockroachDB, MySQL, SQL Server, SQLite) plus the OmniDB ORM layer. Includes an async-first ADO.NET-style manager (ISqlDatabaseManager) with mapped queries, streaming, paging, entity CRUD, bulk operations, transactions with savepoints, and stored procedures — and a higher-level entity API with a fluent LINQ query builder, eager loading, soft delete, optimistic concurrency, schema generation, and migrations.
A library that is meant to extend the SqlKata Query Builder with objects that represent Database and Database Tables. This allows a 'Database' object with its own tables to be constructed, then queried more easily via methods that help build (or run) the query. This differs from Dapper and SqlKata.Execution (which uses Dapper) in that it models the concept of the database, but it also returns raw values and DataTables. SqlKata is just being used behind the scenes to generate the SQL commands. Example: The 'DataBaseTable.Select(params string[] columns)' method will return a query that requests the specified columns from the DataBaseTable object. The TableName is descibed as a property of the DataBaseTable object. The 'DataBaseTable.GetDataTable(params string[] columns)' will use the method described above to create the query, then will run the query against the parent Database object, and finally return a System.Data.DataTable.
Suilder is a SQL query builder for .NET. It is focused on the use of alias objects to reference tables and column names, there are different types of alias, that can use strings or lambda expressions, and support translation of names. The queries are built by combining smaller query fragments, allowing us to build dynamic queries easily. This library is only a query builder, so you have to combine with any other library to execute the queries and mapping the result.
Carrigan.SqlTools provides the shared SQL modeling, reflection, predicate, join, grouping, HAVING, paging, and query-building abstractions used by the Carrigan.SqlTools dialect generator and client packages. Dialect-specific SQL rendering belongs in packages such as Carrigan.SqlTools.Generators.SqlServer and Carrigan.SqlTools.Generators.PostgreSql. Client execution helpers belong in packages such as Carrigan.SqlTools.Clients.SqlServer and Carrigan.SqlTools.Clients.PostgreSql. Most application projects should reference a dialect-specific generator or client package directly. This package is intended as the common foundation for those packages and for shared infrastructure that needs Carrigan.SqlTools model types.
Typed request builders and models for querying OpenAQ air-quality data from .NET.
Query layer (API query objects) for Lazy.Crud
DotnetStandardQueryBuilder.Mongo package contains methods to build Mongo database query from query builder request
A library to facilitate some database interactions that we need to perform in our applications.
DotnetStandardQueryBuilder.AzureCosmosSql package contains methods to build Azure Cosmos database SQL query from query builder request
A CQRS framework for .NET 8/9/10 that is wired at compile time. A Roslyn source generator emits the command, query, stream and notification dispatch and the handler registrations as plain C#, so there is no runtime reflection and the whole thing is trimming- and Native-AOT-safe; analyzers catch wiring mistakes as you type. Pipeline behaviors (validation and exception handling on by default; logging, retries, timeouts, rate limiting, idempotency and unit of work opt-in) and a transactional outbox come behind one fluent builder. Install this meta-package for the full setup: the contracts, the runtime, the pipeline behaviors, the source generator and the analyzers.
These are the implemented engines for Suilder: MySQL, Oracle Database, PostgreSQL, SQLite and SQL Server.
Lightweight C# library that converts JSON-based query definitions into LINQ expressions. Ideal for building dynamic filters, predicates, and queries.