ActiveQueryBuilder.View.WinForms 3.3.0.1036

There is a newer version of this package available.
See the version list below for details.
dotnet add package ActiveQueryBuilder.View.WinForms --version 3.3.0.1036
                    
NuGet\Install-Package ActiveQueryBuilder.View.WinForms -Version 3.3.0.1036
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="ActiveQueryBuilder.View.WinForms" Version="3.3.0.1036" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="ActiveQueryBuilder.View.WinForms" Version="3.3.0.1036" />
                    
Directory.Packages.props
<PackageReference Include="ActiveQueryBuilder.View.WinForms" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add ActiveQueryBuilder.View.WinForms --version 3.3.0.1036
                    
#r "nuget: ActiveQueryBuilder.View.WinForms, 3.3.0.1036"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package ActiveQueryBuilder.View.WinForms@3.3.0.1036
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=ActiveQueryBuilder.View.WinForms&version=3.3.0.1036
                    
Install as a Cake Addin
#tool nuget:?package=ActiveQueryBuilder.View.WinForms&version=3.3.0.1036
                    
Install as a Cake Tool

Visual SQL Query Builder for WinForms that lets users build ad-hoc SQL queries with sub-queries. Active Query Builder has full support of all popular database servers and appropriate SQL dialects. The end-user can combine visual query building with direct SQL query text editing. SQL text editor with code completion and syntax highlighting satisfies the needs of professional query writers.

Product Compatible and additional computed target framework versions.
.NET Framework net is compatible. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
3.13.2.2264 154 4/30/2025
3.13.1.2263 166 4/6/2025
3.13.0.2262 137 3/27/2025
3.12.4.2261 128 2/10/2025
3.12.3.2260 123 2/2/2025
3.12.3.2259 123 2/2/2025
3.12.2.2258 130 12/27/2024
3.12.1.2257 174 11/11/2024
3.12.0.2256 129 10/24/2024
3.11.6.2255 169 9/7/2024
3.11.5.2254 136 8/26/2024
3.11.4.2253 172 7/7/2024
3.11.3.2252 189 4/22/2024
3.11.2.2251 164 3/23/2024
3.11.1.2250 155 3/22/2024
3.11.0.2249 169 3/13/2024
3.10.0.2248 298 12/14/2023
3.9.14.2246 144 12/13/2023
3.9.13.2245 280 9/11/2023
3.9.12.2244 251 5/31/2023
3.9.11.2243 236 5/15/2023
3.9.10.2242 254 4/26/2023
3.9.9.2241 310 4/13/2023
3.9.8.2240 312 3/10/2023
3.9.7.2239 315 2/18/2023
3.9.6.2238 408 1/4/2023
3.9.5.2237 494 10/24/2022
3.9.4.2236 521 9/20/2022
3.9.3.2235 503 9/10/2022
3.9.2.2234 531 8/29/2022
3.9.1.2233 520 8/21/2022
3.9.0.2232 629 7/15/2022
3.8.30.2231 522 7/15/2022
3.8.29.2230 551 7/5/2022
3.8.28.2229 542 7/1/2022
3.8.27.2228 506 6/28/2022
3.8.26.2227 526 6/17/2022
3.8.25.2226 542 6/2/2022
3.8.24.2225 610 5/13/2022
3.8.23.2224 527 5/6/2022
3.8.22.2223 612 4/28/2022
3.8.20.2222 556 4/22/2022
3.8.19.2221 558 4/21/2022
3.8.17.2219 577 2/16/2022
3.8.16.2218 559 1/26/2022
3.8.15.2217 382 1/13/2022
3.8.15.2216 385 1/13/2022
3.8.14.2212 469 12/9/2021
3.8.13.2211 433 12/8/2021
3.8.12.2210 467 11/10/2021
3.8.11.2209 493 11/1/2021
3.8.10.2208 560 9/22/2021
3.8.9.2207 527 8/31/2021
3.8.8.2206 517 8/13/2021
3.8.7.2205 547 7/20/2021
3.8.6.2204 525 7/12/2021
3.8.5.2202 514 6/23/2021
3.8.5.2201 565 6/23/2021
3.8.4.2200 540 6/21/2021
3.8.3.2198 558 6/12/2021
3.8.2.1198 561 5/27/2021
3.8.1.1197 486 5/20/2021
3.8.1.1196 533 5/20/2021
3.8.0.1195 535 5/19/2021
3.7.18.1193 571 3/26/2021
3.7.17.1192 522 3/18/2021
3.7.16.1191 540 3/10/2021
3.7.15.1190 552 3/3/2021
3.7.14.1189 552 2/15/2021
3.7.13.1188 566 2/2/2021
3.7.12.1187 557 1/29/2021
3.7.11.1186 589 1/20/2021
3.7.10.1185 565 1/13/2021
3.7.9.1184 890 1/2/2021
3.7.8.1183 617 12/30/2020
3.7.7.1182 618 12/14/2020
3.7.6.1181 613 11/26/2020
3.7.5.1179 683 10/28/2020
3.7.4.1178 671 10/22/2020
3.7.2.1175 680 9/8/2020
3.7.1.1174 707 8/28/2020
3.7.0.1173 681 8/27/2020
3.6.15.1172 668 8/21/2020
3.6.14.1171 738 8/11/2020
3.6.13.1170 780 8/6/2020
3.6.12.1169 730 8/5/2020
3.6.11.1168 678 8/4/2020
3.6.10.1167 739 7/27/2020
3.6.9.1166 737 7/12/2020
3.6.7.1165 669 7/2/2020
3.6.6.1164 710 6/26/2020
3.6.5.1163 681 6/10/2020
3.6.3.1162 705 6/1/2020
3.6.2.1161 754 5/15/2020
3.6.1.1160 776 5/8/2020
3.6.0.1159 753 4/5/2020
3.5.40.1158 719 3/20/2020
3.5.39.1157 773 3/8/2020
3.5.38.1156 835 2/28/2020
3.5.37.1155 764 2/14/2020
3.5.35.1153 821 1/13/2020
3.5.34.1152 800 12/31/2019
3.5.34.1151 824 12/30/2019
3.5.33.1150 757 12/10/2019
3.5.32.1149 783 11/22/2019
3.5.31.1148 783 11/22/2019
3.5.30.1147 774 11/11/2019
3.5.29.1146 785 11/1/2019
3.5.28.1145 763 10/29/2019
3.5.27.1144 779 10/22/2019
3.5.26.1143 794 10/11/2019
3.5.25.1142 801 10/1/2019
3.5.25.1141 773 9/25/2019
3.5.25.1140 842 8/21/2019
3.5.24.1138 841 8/2/2019
3.5.22.1136 934 7/11/2019
3.5.21.1135 802 6/27/2019
3.5.21.1134 812 6/26/2019
3.5.20.1133 900 6/2/2019
3.5.19.1132 863 5/28/2019
3.5.19.1131 835 5/27/2019
3.5.18.1130 840 5/24/2019
3.5.17.1129 862 5/23/2019
3.5.16.1128 848 5/13/2019
3.5.15.1127 839 4/30/2019
3.5.14.1126 856 4/12/2019
3.5.13.1125 846 3/12/2019
3.5.13.1124 874 3/8/2019
3.5.12.1123 922 2/22/2019
3.5.12.1122 949 2/14/2019
3.5.12.1120 927 2/6/2019
3.5.12.1119 939 2/5/2019
3.5.8.1115 1,037 12/18/2018
3.5.6.1113 1,016 11/29/2018
3.5.6.1112 989 11/26/2018
3.5.5.1110 1,012 11/1/2018
3.5.4.1109 1,032 10/19/2018
3.5.4.1108 1,078 10/17/2018
3.5.3.1106 1,134 9/19/2018
3.5.2.1105 1,108 9/12/2018
3.5.1.1104 1,149 9/3/2018
3.5.0.1103 1,166 8/20/2018
3.4.21.1102 1,100 8/17/2018
3.4.20.1101 1,373 7/13/2018
3.4.19.1100 1,404 7/4/2018
3.4.19.1099 1,346 6/29/2018
3.4.18.1097 1,353 6/21/2018
3.4.16.1093 1,419 5/28/2018
3.4.13.1090 1,391 5/8/2018
3.4.12.1089 1,372 5/7/2018
3.4.11.1088 1,442 4/23/2018
3.4.8.1085 1,464 4/2/2018
3.4.7.1084 1,439 3/7/2018
3.4.6.1083 1,436 3/3/2018
3.4.5.1082 1,228 2/19/2018
3.4.3.1078 1,465 1/26/2018
3.3.25.1073 1,296 12/14/2017
3.3.24.1071 1,273 11/27/2017
3.3.20.1066 1,310 9/22/2017
3.3.16.1063 1,314 8/14/2017
3.3.12.1060 1,354 7/10/2017
3.3.11.1059 1,289 6/28/2017
3.3.10.1057 1,338 6/19/2017
3.3.9.1056 1,354 6/13/2017
3.3.8.1055 1,309 6/5/2017
3.3.7.1054 1,291 6/5/2017
3.3.6.1053 1,336 4/28/2017
3.3.6.1042 1,317 4/26/2017
3.3.3.1039 1,322 3/23/2017
3.3.2.1038 1,325 3/17/2017
3.3.0.1036 1,439 2/27/2017
3.2.2.1035 1,403 1/30/2017
3.2.1.1033 1,372 12/22/2016
3.2.1.1032 1,419 12/9/2016
3.2.1.1031 1,342 11/25/2016
3.2.0.1030 1,364 10/31/2016
3.2.0.1029 1,351 10/27/2016
3.1.1.1028 1,392 9/7/2016
3.1.1.1025 1,348 8/18/2016
3.1.1.1024 1,422 8/8/2016
3.1.1.1022 1,718 7/26/2016
3.1.1.1020 1,411 6/23/2016
3.1.0.1018 1,450 5/12/2016
3.1.0.1017 1,392 5/11/2016
3.1.0.1014 1,449 5/5/2016

1. Improvements in the user queries API.

Previously, to edit the text of the saved user query, the user had to abandon the currently edited query, and the programmer could not keep track of this transition.

+ Now when the user selects the query editing command, the UserQueriesView.EditUserQuery event is triggered, in which the developer can save the current query before opening the new one, or he can open the user query in a new window. Also, the events are now fired on deleting, renaming and moving user queries between the folders. You can review all API changes in the release notes article.
+ The new helper class Core.UserQueries that consists of static methods has been added to perform various manipulations with user queries, such as adding, saving, moving, renaming them. It also has the means to save and load user queries serialized in XML format.

2. Editing Sub-query text apart from the entire query is possible now.
 
The component's API has allowed editing the text of a subquery long ago. The problem is that the text of the query modified by the user may have syntax errors, and the component lets switch to another subquery at any time. The erroneous text can not be saved, as it has to be parsed and translated into an object representation. In order not to lose the user changes when switching between subqueries, the component must be able to block this switch to inform the user of the error and offer ways out of the situation.

+ The new ActiveUnionSubQueryChanging event has been added to the QueryView and QueryBuilder components. The programmer can deny switching between sub-queries in this event handler by setting the e.Abort parameter to true.
+ The new SubQueryBreadcrumbsBar control has been made to display path from the main query to the currently active sub-query. It helps quickly switch to parent sub-queries.

3. Miscellaneous improvements.

+ The new MetadataLoadingOptions.AllowRecursiveVirtualObjects property allows specifying the mode of working with virtual objects. By default, referring to other virtual objects in the text of a virtual object is allowed. Such reference lets build a chain of objects to break complex queries in a series of simple ones. However, in this mode, you can't use the same-named physical object in a virtual object because of the emerging recursion. Setting this property to false prohibits creation chains of virtual objects, but allows to create virtual objects that substitute physical database objects.
+ Query Statistics: The UsedDatabaseObjects and UsedDatabaseObjectFields collections now include invalid objects and fields being used in the query. They differ from valid objects by the absence of MetadataObject (for objects) and MetadataField (for fields) references.
+ Usability of Expression Editor is improved now with the new dockable panels.
+ SQL Text Editor with syntax highlighting is used now to edit joining expression in the Properties bar and dialog.
+ Now it's possible to select multiple rows and drag them to reorder columns in the SELECT list.
+ The new SQLite metadata provider has been added.
- Removal of unused objects from the query when the QueryBuilder.BehaviorOptions.DeleteUnusedObjects property is turned to True has been fixed.