Query Builders

ShadowSql的Dapper扩展

拼接sql工具

Active Query Builder 3 View Components

Active Query Builder ASP.NET Edition is a Visual SQL Query Builder for ASP.NET WebForms, MVC and Core 2.0 environments 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, preview sub-query results. Active Query Builder allows for parsing of complex SQL queries for their visual representation as well as for programmatic analysis and modification.This package should be used in MVC .NET projects. Packages for WebForms and ASP.NET Core environments are available separately.

Smart Blazor Components are built from the ground up to be feature complete, fast, modular, agnostic for device. It includes over 70 components, including datagrid, scheduler, chart, gantt, kanban, excel, pdf and much more. Components Included: DATAGRIDS Grid Tree Grid Table Pivot Table Tree Table DATA VISUALIZATION Gantt Scheduler Chart Gauge Tank Kanban CardView Progress Bar Circular Progress Bar BarCode QRCode CALENDARS Scheduler Calendar DateTimePicker DateRangePicker DateTimeInput TimePicker TimeInput BUTTONS Button Toggle Button Repeat Button Radio Button Split Button Power Button Button Group DropDown Button Chips DROPDOWNS ComboBox MultiComboInput MultiInput MultiCheckInput DropdownList MultiSplitButton NAVIGATION Accordion Breadcrumb Context Menu Menu Ribbon Tabs Tree INPUTS Rich Text Editor Input TextArea Mask TextBox Password TextBox MultiComboInput Phone Input Numeric Textbox Numeric Input Slider CheckBox Radio LAYOUT Window ListMenu Docking Layout Layout Splitter Tooltip NOTIFICATIONS Toast FORMS Form Query Builder Helpful links: License: https://htmlelements.com/license/ Demos: https://htmlelements.com/blazor/ Support: Incident: support@jqwidgets.com Forum: https://www.htmlelements.com/forums/ This is a commercial product and requires a paid license for possession or use. jQWidgets’s licensed software, including this component, is subject to the terms and conditions of jQWidgets's EULA. To acquire a license, you can purchase one at https://www.htmlelements.com/license or start a free 30-day trial. © Copyright 2025 jQWidgets Ltd. All Rights Reserved. The jQWidgets license and copyright applies to this distribution.

Dependency injection builder extensions for the softaware.CQS.Decorators.Validation package.

Build validators for forms (IFormCollection) and queries (IQueryCollection) using a simple fluent interface

SQLite Metadata Provider for Active Query Builder

Syncfusion Bold Reports for Web is a server-side helper package used to build ASP.NET Web API services. Key features: • Users can interactively provide report parameter inputs at run time to display reports based on the parameter. • SQL Server RDL specification expressions are supported. • Built-in SQL Query designer with a convenient user interface to create and view relationships between tables easily. • A rich selection of built-in report items, including charts, grids, pivot grids, subreports, textboxes, images, lines, and rectangles for better visual representation of data. • Report viewer supports multilevel grouping and sorting in data regions of report items such as tablixes, matrices and lists. • Interactive features in RDL specification like drill through, hyperlink, and interactive sorting to work with report at runtime. • Preview the report in print layout prior to printing. Page settings can be modified using page setup dialog. • All static texts within the report viewer and report designer can be localized to any desired language. • Displayed reports can be exported to popular file formats: PDF, Word, Excel, PowerPoint and HTML. Learn more: https://www.boldreports.com/features?utm_source=nuget&utm_medium=listing Documentation: https://help.boldreports.com/embedded-reporting/aspnet-web-forms-reporting?utm_source=nuget&utm_medium=listing Support Questions: mailto:support@boldreports.com?utm_source=nuget&utm_medium=listing This is a commercial product and requires a paid subscription license for possession or use. Syncfusion’s Bold Reports services, including this component, is subject to the terms and conditions of Syncfusion's Bold Reports Software License Agreement and Terms of Service (https://www.boldreports.com/terms-of-use/?utm_source=nuget&utm_medium=listing). To acquire a license, you can start a subscription or start a free 15-day trial here (https://www.boldreports.com/pricing/?utm_source=nuget&utm_medium=listing). This server-side helper package provides services for the following components and libraries: • ASP.NET MVC Report Designer: https://www.boldreports.com/embedded-reporting/aspnet-mvc-report-designer?utm_source=nuget&utm_medium=listing • ASP.NET MVC Report Viewer: https://www.boldreports.com/embedded-reporting/aspnet-mvc-report-viewer?utm_source=nuget&utm_medium=listing • ASP.NET MVC Report Writer: https://www.boldreports.com/embedded-reporting/aspnet-mvc-report-writer?utm_source=nuget&utm_medium=listing • ASP.NET Web Forms Report Designer: https://www.boldreports.com/embedded-reporting/aspnet-web-forms-report-designer?utm_source=nuget&utm_medium=listing • ASP.NET Web Forms Report Viewer: https://www.boldreports.com/embedded-reporting/aspnet-web-forms-report-viewer?utm_source=nuget&utm_medium=listing • ASP.NET Web Forms Report Writer: https://www.boldreports.com/embedded-reporting/aspnet-web-forms-report-writer?utm_source=nuget&utm_medium=listing • Angular Report Viewer: https://www.boldreports.com/embedded-reporting/angular-report-viewer?utm_source=nuget&utm_medium=listing • Angular Report Designer: https://www.boldreports.com/embedded-reporting/angular-report-designer?utm_source=nuget&utm_medium=listing • JavaScript Report Viewer: https://www.boldreports.com/embedded-reporting/javascript-report-viewer?utm_source=nuget&utm_medium=listing • JavaScript Report Designer: https://www.boldreports.com/embedded-reporting/javascript-report-designer?utm_source=nuget&utm_medium=listing © Copyright 2025 Syncfusion, Inc. All Rights Reserved. The Syncfusion Bold Reports license and copyright applies to this distribution.

This package provides the functionality to utilize the features of Syncfusion® Blazor Query Builder component and more.

Tool used to migrate data between Dataverse instances. - Allows data to be exported to JSON format and later imported - Supports Create, Update and Delete operations and attribute specification - Easily filter data by using fetch XML filters - Integration with FetchXML Builder tool for easier query building - Map records using several mapping options (auto or manual)

NOTE: The current package is *DEPRECATED* We moved to here: https://www.nuget.org/packages/Syncfusion.EJ2.Blazor Syncfusion ASP.NET Core Razor Components are built from the ground up to be lightweight, responsive, modular, and touch-friendly. It includes over 50 components, including grid, chart, scheduler, and much more. Key features: • Supports ASP.NET Core Razor Component. • Stunning built-in themes including material, bootstrap, fabric, etc. • Compliance with accessibility standards - WCAG 2.0 and Section 508. Controls Included: GRIDS DataGrid Pivot Table Tree Grid DATA VISUALIZATION Charts Circular Gauge Diagram Heatmap chart Linear Gauge Maps Range Selector Smith Chart Sparkline Charts Stock Chart TreeMap EDITORS Rich Text Editor In-place Editor Word Processor CALENDARS Scheduler Calendar DatePicker DateRangePicker DateTime Picker TimePicker BUTTONS Button ButtonGroup Chips Dropdown Menu Progress Button Split Button DROPDOWNS AutoComplete ComboBox Dropdown List MultiSelect Dropdown NAVIGATION Accordion Context Menu Menu Bar Sidebar Tabs Toolbar TreeView INPUTS TextBox Input Mask Numeric Textbox Radio Button Checkbox Color Picker File Upload Range Slider Toggle Switch Button LAYOUT Avatar Card Dialog ListView Splitter Tooltip NOTIFICATIONS Badge Toast FORMS Query Builder Viewer PDF Viewer Helpful links: Documentation: https://ej2.syncfusion.com/aspnet-core-razor-components/documentation/ Support: Incident: https://www.syncfusion.com/support/directtrac/incidents/newincident Forum: https://www.syncfusion.com/forums/aspnetcore-js2 This is a commercial product and requires a paid license for possession or use. Syncfusion’s licensed software, including this component, is subject to the terms and conditions of Syncfusion's EULA (https://www.syncfusion.com/eula/es/). To acquire a license, you can purchase one at https://www.syncfusion.com/sales/products or start a free 30-day trial here (https://www.syncfusion.com/account/manage-trials/start-trials). © Copyright 2019 Syncfusion, Inc. All Rights Reserved. The Syncfusion Essential Studio license and copyright applies to this distribution.

Dependency injection builder extensions for the softaware.CQS.Decorators.Transaction package.

SqlScribe is a performant and typesafe query builder.

Active Query Builder ASP.NET Edition is a Visual SQL Query Builder for ASP.NET WebForms, MVC and Core 2.0 environments 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, preview sub-query results. Active Query Builder allows for parsing of complex SQL queries for their visual representation as well as for programmatic analysis and modification. This package should be used in WebForms projects. Packages for MVC and ASP.NET Core environments are available separately.

Simple query string builder

This library basically provides you with a simple way to create lambda expressions to filter lists and database queries by delivering an easy-to-use fluent interface that enables the creation, storage and transmission of those filters. Useful to turn WebApi requests parameters into expressions, create advanced search screens with the capability to save and re-run those filters, among other things.

Fluent T-SQL Query Builder

XCommon

Dotnet Report is a powerful .NET Embedded Analytics and Reporting Solution that simplifies adding customizable, user-friendly report-building and data visualization features to your ASP.NET Web Applications. Designed for developers, it offers seamless integration, intuitive interfaces, and robust reporting capabilities to empower end-users with actionable insights. Perfect for businesses looking to enhance data-driven decision-making and streamline reporting workflows.

Provides dynamic linq expression builders and support for string queries for IQueryable

Blazor grid utility to generate a HTML table form a grid builder by a model. Can auto generate column filtering, sortingand pagination.

EntityStore generic querying library

## 🚀 What's New in v2.2.0 - **Latest AI Models**: Full support for newest generation AI models - **OpenAI**: GPT-5 series (Gpt5, Mini, Nano, ChatLatest), GPT-4.1 series - **Anthropic**: Claude 4 series (Opus 4.1, Opus 4, Sonnet 4) - now production ready - **Google**: Gemini 2.5 series (Pro, Flash, FlashLite) - enhanced performance - **Model Migration**: Smooth transition from deprecated enum values - **Production Ready**: All latest models available for production use ## Comprehensive AI Model Support - **OpenAI**: GPT-5, GPT-4.1, GPT-4o (latest, 2024-11-20), GPT-4o-mini - **Anthropic**: Claude 4, Claude 3.7 Sonnet, Claude 3.5 Sonnet/Haiku - **Google**: Gemini 2.5 Pro/Flash/FlashLite, Gemini 2.0 Flash, Gemini 1.5 Pro/Flash - **DeepSeek**: DeepSeek Chat, DeepSeek Reasoner (enhanced reasoning capabilities) - **Perplexity**: Sonar, Sonar Pro, Sonar Reasoning (with web search & citations) ## Key Features (from v2.1.0+) - ✅ **Modern Streaming**: IAsyncEnumerable support with `await foreach` (v2.1.0) - ✅ **Latest Models**: GPT-5, Claude 4, Gemini 2.5 support (v2.2.0) - ✅ **Multimodal**: Text + images for vision-capable models - ✅ **Stateless Mode**: Independent requests without conversation history - ✅ **Fluent API**: Intuitive message builder with method chaining - ✅ **Web Search**: Real-time search with citations (Perplexity) - ✅ **Audio Support**: Text-to-Speech and Speech-to-Text (OpenAI) - ✅ **Token Management**: Precise counting and limits - ✅ **Error Handling**: Comprehensive exception types - ✅ **Backward Compatible**: All existing v1.x and v2.0.x code works ## Quick Examples // Use latest models (v2.2.0) var gptService = new ChatGptService(apiKey, httpClient); gptService.ActivateChat.ChangeModel(AIModel.Gpt5); // New in v2.2.0 var claudeService = new ClaudeService(apiKey, httpClient); claudeService.ActivateChat.ChangeModel(AIModel.ClaudeOpus4_1_250805); // New in v2.2.0 var geminiService = new GeminiService(apiKey, httpClient); geminiService.ActivateChat.ChangeModel(AIModel.Gemini2_5Pro); // New in v2.2.0 // Modern streaming (from v2.1.0) await foreach (var chunk in service.StreamAsync("Explain AI")) { Console.Write(chunk); } // Multimodal with latest models await foreach (var chunk in gptService .BeginMessage() .AddText("Analyze this image") .AddImage("photo.jpg") .StreamAsync()) { ProcessChunk(chunk); } // One-off queries (no conversation history) await foreach (var chunk in service.StreamOnceAsync("Quick question")) { Console.Write(chunk); } // Web search with citations (Perplexity) var result = await sonarService.GetCompletionWithSearchAsync( "Latest AI developments", recencyFilter: "month" ); foreach (var citation in result.Citations) { Console.WriteLine($"{citation.Title}: {citation.Url}"); } ## Important Notes - **GPT-5**: Text completion only (streaming not yet implemented) - **Model Migration**: Update `Gemini15Pro` → `Gemini1_5Pro` - **Extension Methods**: Add `using Mythosia.AI.Extensions;` - **.NET Standard 2.1**: Compatible with .NET Core 3.0+ and .NET 5+

C# Sql Where Clause Parser to be used as Rest Parameters to filter data

SqlHydra.Query is an F# query builder powered by SqlKata.Query that supports SQL Server, PostgreSQL, Sqlite, MySQL and Oracle.

Extension methods to aid in the execution with Dapper of queries written with Flepper..

Contains utilities for facilitating easier testing of AspNetCore projects: - Fakes: - HttpContext - HttpRequest - HttpResponse - HttpCookie & Collection - HttpFeature - HttpHeaderDictionary - Query - Session - WebSockets - Builders for the above - Builder for setting up controllers with all the bits-and-pieces

VistaDB 6 Metadata Provider for Active Query Builder

Provides QueryBuilder abstractions in order to implement QueryBuilder pattern for MongoDB.Driver.

QueryBuilder allows you to create queries against a database, describing them as an object, without using tools such as LinqToSql, ORM, etc. and generate their SQL code in the syntax of the DBMS used

Provides the QueryBuilder pattern for MongoDB.Driver.

Use the Lambda Expression Builder to easily build a filter that you can apply to lists and database queries. You can even use this as a base to allow you to build filters dynamically. Packed with features; you can save and re-run filters, not have to worry about NULL checks (it's automatic), build complex queries with groups and more!

Platz.ObjectBuilder is a Blazor UI component that allows to build Models and Queries visually and generate C# code based on saved json data.

Rudra is a .NET Runtime Expression Builder library that allows developers to create queries at runtime that are not predefined or statically known at compile time.

Allows you to create your SQL queries in an object oriented approach.

DotnetStandardQueryBuilder.Core package contains all the necessary core properties and methods for QueryBuilder package

DBのSelect,Insert,Update,Delete操作を拡張メソッドで提供します。 属性/ラムダ式の指定をもとに内蔵クエリビルダが実行SQLを自動生成します。SQL記述不要でDBを参照更新できます。 This library provides CRUD operations of the database as Extension Methods. By specifying Attribute / Lambda-Expression, You can perform database query/update using Dapper without writing SQL.

PostgreSQL only client with something better than query builder or LINQ

Fluent T-SQL Query Builder for PostgreSQL

SqlKata QueryBuilder implementation for RestSQL

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.

Bold Reports by Syncfusion JavaScript Extension package which contains the designer extension such as Barcode, QR Code, OData, Business Object data, PSQL, SASS, Web API, and Query input dialog. This is a commercial product and requires a paid subscription license for possession or use. Syncfusion’s Bold Reports services, including this component, is subject to the terms and conditions of Syncfusion's Bold Reports Software License Agreement and Terms of Service (https://www.boldreports.com/terms-of-use/?utm_source=nuget&utm_medium=listing). To acquire a license, you can start a subscription or start a free 15-day trial here (https://www.boldreports.com/pricing/?utm_source=nuget&utm_medium=listing). © Copyright {{copyright}} Syncfusion, Inc. All Rights Reserved. The Syncfusion Bold Reports license and copyright applies to this distribution.

Active Query Builder 3 DevExpress Components

A simple library to build SQL queries from ODataQueryOptions.

Query building library based on ADO.NET for simple querying without need to know specific syntax for different sql servers, use connector packages for implementation

Simplifies the use of Qb.Net with Dapper

softaware CQS dependency injection builder extensions Microsoft.Extensions.DependencyInjection framework.

Dapper Query builder

The persistence agnostic query builder library.