A powerful Dynamic Sql Query Builder supporting SQL Server, MySql, PostgreSql, Sqlite, and Oracle
Simple database wrapper for Microsoft SQL Server, MySQL, PostgreSQL, and Sqlite. written in C# supporting dynamic query building and nesting using expressions. Refer to other DatabaseWrapper packages if you only need support for one database type.
Do not install this package directly. Core classes and static methods supporting WatsonORM packages.
WatsonORM is a lightweight and easy to use object-relational mapper (ORM) for Sqlite in C# for .NET Core, .NET Framework, and .NET Standard built on top of DatabaseWrapper. Refer to other WatsonORM packages if you need support for other database types.
WatsonORM is a lightweight and easy to use object-relational mapper (ORM) in C# for .NET Core, .NET Framework, and .NET Standard built on top of DatabaseWrapper. WatsonORM supports Microsoft SQL Server, MySQL, PostgreSQL, and Sqlite databases. Refer to other WatsonORM packages if you only need support for a single database type.
WatsonORM is a lightweight and easy to use object-relational mapper (ORM) for MySQL in C# for .NET Core, .NET Framework, and .NET Standard built on top of DatabaseWrapper. Refer to other WatsonORM packages if you need support for other database types.
WatsonORM is a lightweight and easy to use object-relational mapper (ORM) for SQL Server in C# for .NET Core, .NET Framework, and .NET Standard built on top of DatabaseWrapper. Refer to other WatsonORM packages if you need support for other database types.
WatsonORM is a lightweight and easy to use object-relational mapper (ORM) for PostgreSQL in C# for .NET Core, .NET Framework, and .NET Standard built on top of DatabaseWrapper. Refer to other WatsonORM packages if you need support for other database types.
SQLite Metadata Provider for Active Query Builder
FluentData 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.
SQLWrapper makes it easier to create code wrappers for SQL queries. It's a powerful tool that helps speed up development by reducing the need for manual coding. It works with databases various SQL database (MySQL, MariaDB, ...), checking the syntax and performance of SQL queries before you execute them. It's important to note that SQLWrapper isn't like other tools that map objects to database tables (ORMs). Instead, it directly generates code from your SQL queries and database structure, which performs better than tools like LINQ, EntityFramework, dapper, ... and doesn't have the same limitations. One feature is that it can look at your database's structure to check if your SQL queries are correct, and it can create an XML file listing all the data your queries need and return. Then, you can use XSLT templates to turn that XML into code in languages like C#, and more. Overall, DAIKOZ.SQLWrapper is a handy tool for making SQL code easier to work with, saving time, and helping you write better code.
SqExpress is for those who like SQL but hate raw strings. It lets you build SQL directly in C# with strong typing and IntelliSense, while keeping the code close to real SQL and avoiding LINQ translation. Key features: - Strongly typed SQL AST with export to MS T-SQL, PostgreSQL, MySQL, and SQLite - Cross-dialect JSON extraction, construction, mutation, array-to-table expansion, and relational JSON output - Complex query building with joins, subqueries, CTEs, set operators, analytic/window functions, and MERGE-style workflows - Syntax tree traversal and modification for dynamic query scenarios - T-SQL parser (`SqTSqlParser`) for importing supported SQL into SqExpress AST - Fail-closed validation and security-predicate rewriting workflows for AI-generated T-SQL within the supported parser surface - T-SQL to SqExpress transpilation, analyzer support, and code fixes - Table descriptors, create/drop script generation, and DTO/SqModel generation - Database-first scaffolding for table descriptors and models - Table descriptor generation from Entity Framework models - Live database metadata retrieval and table-list comparison with flags-based diff/inclusion helpers - Foreign-key graph navigation and join-path discovery with `TablesGraph` - Lightweight ADO.NET-based data access for MS SQL Client, Npgsql, MySQL connectors, and Sqlite SqExpress works well for both code-first and database-first workflows. Here's an article that explains the library principles: ["Syntax Tree and Alternative to LINQ in Interaction with SQL Databases"](https://itnext.io/syntax-tree-and-alternative-to-linq-in-interaction-with-sql-databases-656b78fe00dc?source=friends_link&sk=f5f0587c08166d8824b96b48fe2cf33c)
Multi-dialect sql builder with advanced mapping and custom extensions for Database-First applications. SharpSqlBuilder takes your models and maps them to SQL text queries.
A free .NET library to help you to build sql strings using C# object notation, making easier to write conditional queries with no hard-typed strings on the code.
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.
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.
These are the implemented engines for Suilder: MySQL, Oracle Database, PostgreSQL, SQLite and SQL Server.
Lightweight SQLite query-building client for C#.
LINQ query builder and object mapping extensions for CloudflareD1.NET. Provides CompiledQuery for 95% faster repeated query execution with automatic expression tree caching, IQueryable<T> with deferred execution, async streaming with IAsyncEnumerable<T> for memory-efficient result processing, Set Operations (Union, UnionAll, Intersect, Except), Distinct() for removing duplicates, Contains()/IN clause for collection filtering, Join operations (INNER JOIN, LEFT JOIN), Having clause for filtered aggregations, GroupBy with aggregations (Count, Sum, Average, Min, Max), type-safe query construction with expression trees, Select() projection with computed properties, entity mapping, and fluent API for building SQL queries using lambda expressions. All query methods support CancellationToken.
SqlOM is a software component which allows you to programmatically create SQL queries at runtime using a convenient .NET Object Model, thus creating an abstraction layer over SQL. Supports SQL Server, Oracle, MySQL, MariaDB, SQLite, and PostgreSQL with modern C# features including fluent API, Common Table Expressions, and first-class parameterized query output.
Data access layer of Sail2025 framework, providing unified database access interface. Supports multiple databases (SQL Server, MySQL, PostgreSQL, SQLite, Oracle, Dameng), including ORM mapping, query builder, transaction management, pagination query and other features.
A type-safe SQL query builder for .NET with predictable SQL, compatible with NativeAOT.
A fluent, cache-aware SQLite persistence layer for .NET MAUI: a generic repository with Select / Insert / Update / Delete accessors, expression-to-SQL translation (projections, joins, grouping, aggregates) that keeps filters in the database rather than in memory, debounced in-memory caches for hot reference tables, ordered schema migrations, and consistent GUID-id handling for stores whose rows can arrive in any case. Application behaviour — audit fields, soft delete, tenancy, sync metadata, conflict policy, value converters — is injected through a configuration builder, entity descriptors, and an interceptor pipeline; the package knows nothing about your domain.
High-performance zero-SQL object-relational mapper for .NET: write typed C# LINQ-like queries and get compiled, parameterized SQL for SQLite, SQL Server, PostgreSQL, MySQL, MariaDB and ClickHouse, with no change tracking and no mandatory entity classes.
Universal data access abstraction layer providing ADO.NET enhancements, schema management, connection/transaction scoping, and database-agnostic persistence. Includes DAC helpers, SQL execution and query building, CSV support, and common extensions used by provider packages (SQLite, SQL Server, Firebird, MySQL, PostgreSQL, Oracle, NHibernate).
SQLite provider for ForgeORM.
A fully-fledged C# dialect of SQL — fluent, type-safe SELECT and DML (INSERT, UPDATE, DELETE) for .NET 6+. Covers every ANSI SQL clause with full identifier quoting for SQL Server, MySQL/MariaDB, SQLite, PostgreSQL, and ANSI Generic dialects. Configure once at startup via QBuilderConfig, use named configs for multiple databases. Produces parameterized SQL strings you execute with Dapper, ADO.NET, or any micro-ORM. Zero boilerplate, injection-safe, 255 tests. v9.2 adds POCO convenience: FromObject/FromObjects for INSERT/UPDATE/DELETE, QBatch for multi-statement round-trips, and QKey/QIgnore/QColumn attributes.
Translate QuerySpec filter specifications into LINQ expression trees that Entity Framework Core turns into SQL. 50+ operators (comparison, string, collection, temporal, null/membership, regex, geospatial), nested AND/OR/XOR groups, and a compiled-expression cache that keeps translation cheap on hot paths. Use this when filter or sort input comes from an HTTP request, a saved view, a rules engine, or a config file — instead of writing expression trees by hand or interpolating SQL strings. Tested against the EF Core In-Memory, SQLite, SQL Server, and PostgreSQL providers. Multi-targets .NET 8 (LTS), .NET 9, and .NET 10 (LTS).
SQLite provider for Nextorm, a zero-SQL ORM for .NET: adds the SQLite dialect ($name parameters, limit/offset paging, custom aggregates) and UseSqlite() over Microsoft.Data.Sqlite.
A multi-provider .NET database access library (SQL Server, PostgreSQL, MySQL, SQLite) with parameterized queries, LINQ expression support, CRUD utilities, JOINs, upsert, and built-in security features.
Renders a Querio query into parameterized SQL. Ships dialects for SQL Server, PostgreSQL and SQLite, each declaring what it can and cannot do so an unsupported query fails loudly instead of silently answering a different question.
Simple database wrapper for Microsoft SQL Server, MySQL, PostgreSQL, and Sqlite. written in C# supporting dynamic query building and nesting using expressions. Refer to other DatabaseWrapper packages if you only need support for one database type.
Strongly Typed Query Builder + Data Context with Dapper for Sqlite
Enhance your SQLite database queries with DbSyncKit.Templates.SQLite. This package delivers templates for SELECT, INSERT, UPDATE, DELETE, and COMMENT queries, simplifying SQL operations for improved readability and efficiency.