Query Builders

The "NotBetween" operation for the "ExpressionBuilder" package. ExpressionBuilder allows you to easily build a filter that can be applied to lists and database queries (even dynamically). Packed with features, you can: easily convert API requests into expressions, save and re-run filters, have `NULL` checks done automatically, build complex queries with groups and so much more!

The "IsEmpty" operation for the "ExpressionBuilder" package. ExpressionBuilder allows you to easily build a filter that can be applied to lists and database queries (even dynamically). Packed with features, you can: easily convert API requests into expressions, save and re-run filters, have `NULL` checks done automatically, build complex queries with groups and so much more!

The "In" operation for the "ExpressionBuilder" package. ExpressionBuilder allows you to easily build a filter that can be applied to lists and database queries (even dynamically). Packed with features, you can: easily convert API requests into expressions, save and re-run filters, have `NULL` checks done automatically, build complex queries with groups and so much more!

The "LessThanOrEqual" operation for the "ExpressionBuilder" package. ExpressionBuilder allows you to easily build a filter that can be applied to lists and database queries (even dynamically). Packed with features, you can: easily convert API requests into expressions, save and re-run filters, have `NULL` checks done automatically, build complex queries with groups and so much more!

Looking to exapnd the functionality of the "ExpressionBuilder" package? This is the starting point for you. ExpressionBuilder allows you to easily build a filter that can be applied to lists and database queries (even dynamically). Packed with features, you can: easily convert API requests into expressions, save and re-run filters, have `NULL` checks done automatically, build complex queries with groups and so much more!

The "NotBetweenExclusive" operation for the "ExpressionBuilder" package. ExpressionBuilder allows you to easily build a filter that can be applied to lists and database queries (even dynamically). Packed with features, you can: easily convert API requests into expressions, save and re-run filters, have `NULL` checks done automatically, build complex queries with groups and so much more!

The "GreaterThan" operation for the "ExpressionBuilder" package. ExpressionBuilder allows you to easily build a filter that can be applied to lists and database queries (even dynamically). Packed with features, you can: easily convert API requests into expressions, save and re-run filters, have `NULL` checks done automatically, build complex queries with groups and so much more!

The "DoesNotContain" operation for the "ExpressionBuilder" package. ExpressionBuilder allows you to easily build a filter that can be applied to lists and database queries (even dynamically). Packed with features, you can: easily convert API requests into expressions, save and re-run filters, have `NULL` checks done automatically, build complex queries with groups and so much more!

The "StartsWith" operation for the "ExpressionBuilder" package. ExpressionBuilder allows you to easily build a filter that can be applied to lists and database queries (even dynamically). Packed with features, you can: easily convert API requests into expressions, save and re-run filters, have `NULL` checks done automatically, build complex queries with groups and so much more!

The "IsNullOrWhiteSpace" operation for the "ExpressionBuilder" package. ExpressionBuilder allows you to easily build a filter that can be applied to lists and database queries (even dynamically). Packed with features, you can: easily convert API requests into expressions, save and re-run filters, have `NULL` checks done automatically, build complex queries with groups and so much more!

The "SmartSearch" operation for the "ExpressionBuilder" package. ExpressionBuilder allows you to easily build a filter that can be applied to lists and database queries (even dynamically). Packed with features, you can: easily convert API requests into expressions, save and re-run filters, have `NULL` checks done automatically, build complex queries with groups and so much more!

The "DoesNotEndWith" operation for the "ExpressionBuilder" package. ExpressionBuilder allows you to easily build a filter that can be applied to lists and database queries (even dynamically). Packed with features, you can: easily convert API requests into expressions, save and re-run filters, have `NULL` checks done automatically, build complex queries with groups and so much more!

Visual SQL Query Builder for classic ASP.NET and MVC environemnts, Razor and ASPX view engines, with full support of all popular database servers and appropriate SQL dialects. Working with Active Query Builder the end-user can combine visual query building with direct SQL query text editing. Active Query Builder allows for parsing of complex SQL queries for their visual representation as well as for programmatic analysis and modification.

Queries.Renderers.SqlServer Class Library

Dynamic Linq Query Builder base on Expressions (core). Excellent PrepareQuery method with QueryParams

RQL.NET is a resource query language for .NET intended for use with REST apps. It provides a simple, hackable api for creating dynamic sql queries from user submitted JSON.

XCommon

The Dapper SqlBuilder component, for building SQL queries dynamically.

A powerful Dynamic Sql Query Builder supporting SQL Server, MySql, PostgreSql, Sqlite, and Oracle

Adds the execution capabilities for SqlKata

Fluent Sql builder is a package that allows developers to build a Sql Command or Sql Statement with Parameters using a strongly typed system similiar to LINQ without the hassle of maintaining a db context.

Sql builder is a package that allows developers to build a Sql Command or Sql Statement with Parameters using a strongly typed system similiar to LINQ without the hassle of maintaining a db context.

A C# query builder for Azure Digital Twins based on Azure Digital Twins SDK.

A C# Server side component for the popuplar jQuery datatables plugin http://datatables.net/

A tool to build GraphQL query from a C# model.

A simple dynamic expression-tree query builder. You pass it a nested collection of filters for an object, and it materializes a query capable of acting as the filter to an arbitrary collection.

Dapper Query Builder using Fluent API and String Interpolation

Build queries for Microsoft Dataverse and the Power Platform. Investigate data. Fix the layouts. Get code. Let AI fix what you can't. Empower yourself to achieve more. Read more: https://fetchxmlbuilder.com/ FetchXML Builder is used to create and execute queries against Microsoft Dataverse / Power Apps / Dynamics 365. What you don't know about Dataverse this morning, you'll know this afternoon. If you can't solve it, ask in the integrated AI Chat. The tool will assist in three major areas: 1. Constructing queries, including more advanced features like: - aggregates - outer joins - complex "not-in"-queries - attributes from multi-level linked entities - update existing views with altered queries 2. Querying CDS/CRM for information not (easily) found in the UI - system / internal entities - attributes hidden in CRM UI - join on other fields than relationships 3. Developer assistance generating code for - C# QueryExpression code - WebAPI / OData query string - Power Automate List Records - SQL, JavaScript and C# stubs - Easy to use UI to compose queries for reports in CRM The tool reads metadata from Microsoft Dataverse and Dynamics 365 / CRM to assist with selecting entities, attributes, relations and to perform validation of condition values. To make it even more appealing, there is also the possibility to have it show "Friendly names", which will replace the technical names of entities and attributes with their display names in the users' currently selected language, much like Advanced Find does.

Active Query Builder 3 Core Components

This projects forked from PoweredSoft/DynamicQuery

Easy UI to design view layouts and alter queries using FetchXML Builder

Spry - fluent CRUD queries using Dapper

A powerful Dynamic Sql Query Builder supporting Sql Server, MySql, PostgreSql, Oracle and Firebird

Query builder project to support linq alike defined GraphQL queries/mutations.

SqExpress is a SQL query builder that allows you to create SQL expressions directly in C# code with strong typing and IntelliSense (without LINQ!). The library provides a generic SQL syntax tree with export to MS T-SQL, PostgreSQL, and MySQL text. It includes polyfills to compensate for features lacking in certain databases, such as the "MERGE" command. It also provides a set of builders and operators that will help you build complex SQL expressions. It does not use LINQ, and your C# code will be as close to real SQL as possible. This makes it ideal when you need full SQL flexibility to create efficient DB requests. SqExpress comes with a simple but efficient data access mechanism that wraps ADO.Net DbConnection and can be used with MS SQL Client, Npgsql, or MySQL Connector. You can use SqExpress together with the “Code First” concept when you declare SQL tables as C# classes with the possibility to generate recreation scripts for a target platform (MS SQL or PostgreSQL or MySQL). You can also use it in conjunction with the “Database First” concept using an included code modification utility. The utility can also be used to generate flexible DTO classes with all required database mappings. 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)

Elasticsearch Bulk and Search is a high level library to make easy basic query operations (get, search and scroll) and index operations (single index or bulk), besides paging, sorting and query buider.

Simple and powerful SQL builder

Do not install this package directly. Core classes for DatabaseWrapper packages.

This projects makes it easier to use dynamic query in a asp.net core mvc project.

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.

(Unofficial) Signed - A powerful Dynamic Sql Query Builder supporting Sql Server, MySql, PostgreSql, Oracle and Firebird

A C# library which helps create customized and extensible LINQ-like sql queries more easily.

Simple database wrapper for Sqlite written in C# supporting dynamic query building and nesting using expressions. Refer to other DatabaseWrapper packages for support for SQL Server, MySQL, and PostgreSQL.

A simple library to build SQL queries from ODataQueryOptions.

The simplest implementation of OData client. ## Restrictions - Not support XML (JSON only) - Not support Query Builder ## Usage ``` var client = new HttpClient(); var odata = new ODataClient(client); var request = Request.Get($"{endpoint}/Products?$inlinecount=allpages"); var response = await odata.SendAsync(request); if (response.Success) { var total = response.ReadAs<int>("$['odata.count']"); var products = response.ReadAs<IEnumerable<Product>>("$.value"); } ``` ## More info [https://github.com/iwate/ODataHttpClient](https://github.com/iwate/ODataHttpClient)

Simple database wrapper for MySQL written in C# supporting dynamic query building and nesting using expressions. Refer to other DatabaseWrapper packages for support for SQL Server, Sqlite, and PostgreSQL.

Simple database wrapper for SQL Server written in C# supporting dynamic query building and nesting using expressions. Refer to other DatabaseWrapper packages for support for MySQL, Sqlite, and PostgreSQL.

Simple database wrapper for Postgresql written in C# supporting dynamic query building and nesting using expressions. Refer to other DatabaseWrapper packages for support for SQL Server, Sqlite, and MySQL.

Do not install this package directly. Core classes and static methods supporting WatsonORM packages.

Provides the QueryBuilder pattern for Microsoft.EntityFrameworkCore.