ActiveQueryBuilder.Web.MVC
3.8.1.438
See the version list below for details.
dotnet add package ActiveQueryBuilder.Web.MVC --version 3.8.1.438
NuGet\Install-Package ActiveQueryBuilder.Web.MVC -Version 3.8.1.438
<PackageReference Include="ActiveQueryBuilder.Web.MVC" Version="3.8.1.438" />
paket add ActiveQueryBuilder.Web.MVC --version 3.8.1.438
#r "nuget: ActiveQueryBuilder.Web.MVC, 3.8.1.438"
// Install ActiveQueryBuilder.Web.MVC as a Cake Addin #addin nuget:?package=ActiveQueryBuilder.Web.MVC&version=3.8.1.438 // Install ActiveQueryBuilder.Web.MVC as a Cake Tool #tool nuget:?package=ActiveQueryBuilder.Web.MVC&version=3.8.1.438
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.
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net452 is compatible. net46 was computed. net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETFramework 4.5.2
- ActiveQueryBuilder.Core (= 3.8.1.1197)
- Newtonsoft.Json (>= 6.0.4)
-
.NETStandard 2.1
- ActiveQueryBuilder.Core (= 3.8.1.1197)
- Newtonsoft.Json (>= 6.0.4)
NuGet packages (1)
Showing the top 1 NuGet packages that depend on ActiveQueryBuilder.Web.MVC:
Package | Downloads |
---|---|
ActiveQueryBuilder.Web.SignalR
This package adds support for SignalR web transfer protocol to Active Query Builder. 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. |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
3.11.7.489 | 191 | 10/6/2024 |
3.11.6.488 | 148 | 9/7/2024 |
3.11.5.487 | 150 | 8/27/2024 |
3.11.4.486 | 162 | 7/7/2024 |
3.11.3.485 | 123 | 6/30/2024 |
3.11.2.484 | 218 | 4/3/2024 |
3.10.2.484 | 155 | 4/2/2024 |
3.10.1.483 | 495 | 12/18/2023 |
3.10.0.482 | 190 | 12/14/2023 |
3.9.14.481 | 198 | 12/13/2023 |
3.9.13.480 | 232 | 9/11/2023 |
3.9.12.479 | 216 | 5/31/2023 |
3.9.11.478 | 220 | 5/15/2023 |
3.9.10.477 | 233 | 4/26/2023 |
3.9.9.476 | 236 | 4/13/2023 |
3.9.8.475 | 276 | 3/15/2023 |
3.9.8.474 | 266 | 3/10/2023 |
3.9.7.473 | 10,965 | 2/18/2023 |
3.9.6.472 | 381 | 1/4/2023 |
3.9.5.471 | 472 | 10/24/2022 |
3.9.4.470 | 475 | 9/20/2022 |
3.9.3.469 | 476 | 9/10/2022 |
3.9.2.468 | 465 | 8/29/2022 |
3.9.1.467 | 453 | 8/24/2022 |
3.9.1.466 | 474 | 8/22/2022 |
3.9.1.465 | 461 | 8/21/2022 |
3.9.0.464 | 498 | 7/22/2022 |
3.8.29.463 | 514 | 7/5/2022 |
3.8.28.462 | 491 | 7/1/2022 |
3.8.27.461 | 496 | 6/28/2022 |
3.8.26.460 | 479 | 6/17/2022 |
3.8.25.459 | 502 | 6/2/2022 |
3.8.24.458 | 487 | 5/13/2022 |
3.8.23.457 | 483 | 5/6/2022 |
3.8.22.456 | 504 | 4/28/2022 |
3.8.21.455 | 486 | 4/26/2022 |
3.8.20.454 | 518 | 4/22/2022 |
3.8.17.453 | 587 | 2/16/2022 |
3.8.16.452 | 540 | 1/27/2022 |
3.8.15.451 | 396 | 1/14/2022 |
3.8.14.450 | 383 | 12/9/2021 |
3.8.13.449 | 352 | 12/8/2021 |
3.8.12.448 | 419 | 11/12/2021 |
3.8.11.447 | 402 | 11/1/2021 |
3.8.10.446 | 425 | 10/22/2021 |
3.8.9.445 | 423 | 8/31/2021 |
3.8.8.444 | 407 | 8/13/2021 |
3.8.7.443 | 432 | 7/20/2021 |
3.8.6.442 | 487 | 7/12/2021 |
3.8.5.441 | 472 | 6/23/2021 |
3.8.4.440 | 429 | 6/22/2021 |
3.8.1.438 | 496 | 5/21/2021 |
3.7.18.437 | 554 | 3/26/2021 |
3.7.17.436 | 463 | 3/18/2021 |
3.7.16.435 | 470 | 3/10/2021 |
3.7.15.434 | 454 | 3/3/2021 |
3.7.14.433 | 479 | 2/17/2021 |
3.7.14.432 | 468 | 2/15/2021 |
3.7.13.431 | 507 | 2/2/2021 |
3.7.12.430 | 485 | 1/29/2021 |
3.7.11.429 | 544 | 1/20/2021 |
3.7.10.428 | 510 | 1/13/2021 |
3.7.9.427 | 556 | 1/2/2021 |
3.7.8.427 | 538 | 1/2/2021 |
3.7.8.426 | 482 | 12/30/2020 |
3.7.7.425 | 525 | 12/14/2020 |
3.7.6.424 | 506 | 11/25/2020 |
3.7.5.423 | 556 | 10/28/2020 |
3.7.4.422 | 537 | 10/26/2020 |
3.7.2.419 | 600 | 9/10/2020 |
3.7.2.418 | 606 | 9/8/2020 |
3.7.1.417 | 585 | 8/28/2020 |
3.7.0.416 | 579 | 8/27/2020 |
3.6.15.415 | 585 | 8/21/2020 |
3.6.14.414 | 705 | 8/11/2020 |
3.6.13.413 | 655 | 8/6/2020 |
3.6.12.412 | 624 | 8/5/2020 |
3.6.11.411 | 640 | 8/4/2020 |
3.6.10.410 | 678 | 7/27/2020 |
3.6.9.409 | 663 | 7/12/2020 |
3.6.8.408 | 631 | 7/3/2020 |
3.6.7.407 | 579 | 7/2/2020 |
3.6.6.406 | 653 | 6/26/2020 |
3.6.4.404 | 676 | 6/2/2020 |
3.6.3.403 | 662 | 6/1/2020 |
3.6.2.402 | 673 | 5/15/2020 |
3.6.1.401 | 660 | 5/8/2020 |
3.6.0.400 | 609 | 4/22/2020 |
3.4.10.15 | 703 | 3/20/2020 |
3.4.9.14 | 696 | 3/8/2020 |
3.4.8.13 | 720 | 1/15/2020 |
3.4.8.12 | 707 | 12/31/2019 |
3.4.8.11 | 651 | 12/30/2019 |
3.4.8.10 | 669 | 11/25/2019 |
3.4.8.9 | 666 | 11/22/2019 |
3.4.8.8 | 698 | 11/22/2019 |
3.4.8.7 | 697 | 11/1/2019 |
3.4.8.6 | 693 | 10/29/2019 |
3.4.8.5 | 687 | 10/22/2019 |
3.4.8.3 | 707 | 10/1/2019 |
3.4.8.1 | 716 | 9/26/2019 |
3.4.8 | 755 | 8/21/2019 |
3.4.7.2 | 742 | 8/2/2019 |
3.4.7.1 | 773 | 6/27/2019 |
3.4.7 | 681 | 6/26/2019 |
3.4.6 | 796 | 6/2/2019 |
3.4.5 | 730 | 5/24/2019 |
3.4.4 | 749 | 5/1/2019 |
3.4.3.1 | 736 | 4/16/2019 |
3.4.3 | 759 | 4/16/2019 |
3.4.2 | 784 | 3/13/2019 |
3.4.1 | 760 | 3/10/2019 |
3.4.0 | 824 | 2/15/2019 |
3.3.7 | 871 | 2/6/2019 |
3.3.6 | 888 | 12/18/2018 |
3.3.5 | 873 | 11/27/2018 |
3.3.4 | 903 | 11/2/2018 |
3.3.3 | 891 | 10/22/2018 |
3.3.2 | 920 | 9/20/2018 |
3.3.1 | 953 | 9/12/2018 |
3.3.0 | 963 | 9/3/2018 |
3.2.5 | 1,051 | 7/17/2018 |
3.2.4.1 | 1,054 | 7/5/2018 |
3.2.4 | 1,118 | 7/3/2018 |
3.2.3 | 1,097 | 6/22/2018 |
3.2.2 | 1,122 | 5/10/2018 |
3.2.1 | 1,131 | 4/25/2018 |
3.2.0 | 1,159 | 4/2/2018 |
3.1.2.1 | 1,151 | 3/27/2018 |
3.1.1 | 1,276 | 3/10/2018 |
3.1.0 | 1,154 | 2/20/2018 |
+ User Interface Improvements
* Four columns of the Query Columns List are merged into two for easier reading and
changing the query column options. "Sort Order" and "Sort Type" became "Sorting";
"Grouping" and "Aggregate" are now "Group/Aggregate".
* The way the user works with grouping and aggregation via the datasource field context
menu on the Design Pane has been changed. The user sees if multiple columns of the same
field exist in the query, can explicitly add and remove them. The selection of a new
aggregate function via the context menu doesn't add a new column to the query but
changes the properties of the existing column.
* When several foreign keys exist between a pair of database objects, their addition
to the query leads to linking them only by one particular foreign key, not by all of
them at a time. The user can switch the foreign key of the link between such objects
using the special button. It is displayed when the link is selected.
+ SQL Generation
* The component can automatically generate short aliases for newly added objects. Use
the BehaviorOptions.GenerateShortObjectAliases property to turn it on and off.
* The component can normalize object names found in the query according to the database
schema or leave them untouched. The new SqlGenerationOptions.ObjectNamesNormalization
property controls this behavior.
+ Metadata Handling
* It is now possible to hide from the user (but not remove) unwanted objects and fields
in the Metadata Container. Use the new property MetadataItem.Visible for this purpose.
* The new bool property MetadataField.DisplayInLookup identifies fields suitable for record
identification in lookup controls.
* The new list property MetadataField.EnumValues lets ease the user selection of enum-coded values.
+ ASP.NET Edition
* Severe problems with disposing of the component before its complete initialization are fixed.
* Thread-safe methods to initialize the component are added.
* Demos: The new React demo illustrating the component's use in a SPA application backed with
a microservice architecture is added.
* Demos: The new scalable multi-container Redis-backed demo project with a custom state storage
provider is made.