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.
#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 153 4/30/2025
3.13.1.2263 165 4/6/2025
3.13.0.2262 137 3/27/2025
3.12.4.2261 127 2/10/2025
3.12.3.2260 122 2/2/2025
3.12.3.2259 122 2/2/2025
3.12.2.2258 129 12/27/2024
3.12.1.2257 173 11/11/2024
3.12.0.2256 128 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 249 5/31/2023
3.9.11.2243 234 5/15/2023
3.9.10.2242 252 4/26/2023
3.9.9.2241 308 4/13/2023
3.9.8.2240 310 3/10/2023
3.9.7.2239 313 2/18/2023
3.9.6.2238 406 1/4/2023
3.9.5.2237 492 10/24/2022
3.9.4.2236 519 9/20/2022
3.9.3.2235 501 9/10/2022
3.9.2.2234 529 8/29/2022
3.9.1.2233 518 8/21/2022
3.9.0.2232 627 7/15/2022
3.8.30.2231 520 7/15/2022
3.8.29.2230 549 7/5/2022
3.8.28.2229 540 7/1/2022
3.8.27.2228 504 6/28/2022
3.8.26.2227 524 6/17/2022
3.8.25.2226 540 6/2/2022
3.8.24.2225 608 5/13/2022
3.8.23.2224 525 5/6/2022
3.8.22.2223 610 4/28/2022
3.8.20.2222 554 4/22/2022
3.8.19.2221 556 4/21/2022
3.8.17.2219 575 2/16/2022
3.8.16.2218 557 1/26/2022
3.8.15.2217 380 1/13/2022
3.8.15.2216 383 1/13/2022
3.8.14.2212 467 12/9/2021
3.8.13.2211 431 12/8/2021
3.8.12.2210 465 11/10/2021
3.8.11.2209 491 11/1/2021
3.8.10.2208 558 9/22/2021
3.8.9.2207 525 8/31/2021
3.8.8.2206 515 8/13/2021
3.8.7.2205 545 7/20/2021
3.8.6.2204 523 7/12/2021
3.8.5.2202 512 6/23/2021
3.8.5.2201 563 6/23/2021
3.8.4.2200 538 6/21/2021
3.8.3.2198 556 6/12/2021
3.8.2.1198 559 5/27/2021
3.8.1.1197 484 5/20/2021
3.8.1.1196 531 5/20/2021
3.8.0.1195 533 5/19/2021
3.7.18.1193 569 3/26/2021
3.7.17.1192 520 3/18/2021
3.7.16.1191 538 3/10/2021
3.7.15.1190 550 3/3/2021
3.7.14.1189 550 2/15/2021
3.7.13.1188 564 2/2/2021
3.7.12.1187 555 1/29/2021
3.7.11.1186 587 1/20/2021
3.7.10.1185 563 1/13/2021
3.7.9.1184 888 1/2/2021
3.7.8.1183 615 12/30/2020
3.7.7.1182 616 12/14/2020
3.7.6.1181 611 11/26/2020
3.7.5.1179 681 10/28/2020
3.7.4.1178 669 10/22/2020
3.7.2.1175 678 9/8/2020
3.7.1.1174 705 8/28/2020
3.7.0.1173 679 8/27/2020
3.6.15.1172 666 8/21/2020
3.6.14.1171 736 8/11/2020
3.6.13.1170 778 8/6/2020
3.6.12.1169 728 8/5/2020
3.6.11.1168 676 8/4/2020
3.6.10.1167 737 7/27/2020
3.6.9.1166 735 7/12/2020
3.6.7.1165 667 7/2/2020
3.6.6.1164 708 6/26/2020
3.6.5.1163 679 6/10/2020
3.6.3.1162 704 6/1/2020
3.6.2.1161 752 5/15/2020
3.6.1.1160 774 5/8/2020
3.6.0.1159 750 4/5/2020
3.5.40.1158 716 3/20/2020
3.5.39.1157 770 3/8/2020
3.5.38.1156 832 2/28/2020
3.5.37.1155 761 2/14/2020
3.5.35.1153 818 1/13/2020
3.5.34.1152 797 12/31/2019
3.5.34.1151 821 12/30/2019
3.5.33.1150 754 12/10/2019
3.5.32.1149 780 11/22/2019
3.5.31.1148 780 11/22/2019
3.5.30.1147 771 11/11/2019
3.5.29.1146 782 11/1/2019
3.5.28.1145 760 10/29/2019
3.5.27.1144 776 10/22/2019
3.5.26.1143 791 10/11/2019
3.5.25.1142 798 10/1/2019
3.5.25.1141 770 9/25/2019
3.5.25.1140 839 8/21/2019
3.5.24.1138 838 8/2/2019
3.5.22.1136 931 7/11/2019
3.5.21.1135 799 6/27/2019
3.5.21.1134 809 6/26/2019
3.5.20.1133 897 6/2/2019
3.5.19.1132 860 5/28/2019
3.5.19.1131 832 5/27/2019
3.5.18.1130 837 5/24/2019
3.5.17.1129 859 5/23/2019
3.5.16.1128 845 5/13/2019
3.5.15.1127 836 4/30/2019
3.5.14.1126 853 4/12/2019
3.5.13.1125 843 3/12/2019
3.5.13.1124 871 3/8/2019
3.5.12.1123 919 2/22/2019
3.5.12.1122 946 2/14/2019
3.5.12.1120 924 2/6/2019
3.5.12.1119 936 2/5/2019
3.5.8.1115 1,034 12/18/2018
3.5.6.1113 1,013 11/29/2018
3.5.6.1112 986 11/26/2018
3.5.5.1110 1,009 11/1/2018
3.5.4.1109 1,029 10/19/2018
3.5.4.1108 1,075 10/17/2018
3.5.3.1106 1,131 9/19/2018
3.5.2.1105 1,105 9/12/2018
3.5.1.1104 1,146 9/3/2018
3.5.0.1103 1,163 8/20/2018
3.4.21.1102 1,096 8/17/2018
3.4.20.1101 1,364 7/13/2018
3.4.19.1100 1,395 7/4/2018
3.4.19.1099 1,337 6/29/2018
3.4.18.1097 1,344 6/21/2018
3.4.16.1093 1,410 5/28/2018
3.4.13.1090 1,382 5/8/2018
3.4.12.1089 1,362 5/7/2018
3.4.11.1088 1,433 4/23/2018
3.4.8.1085 1,455 4/2/2018
3.4.7.1084 1,430 3/7/2018
3.4.6.1083 1,427 3/3/2018
3.4.5.1082 1,222 2/19/2018
3.4.3.1078 1,456 1/26/2018
3.3.25.1073 1,290 12/14/2017
3.3.24.1071 1,267 11/27/2017
3.3.20.1066 1,304 9/22/2017
3.3.16.1063 1,308 8/14/2017
3.3.12.1060 1,348 7/10/2017
3.3.11.1059 1,283 6/28/2017
3.3.10.1057 1,332 6/19/2017
3.3.9.1056 1,347 6/13/2017
3.3.8.1055 1,303 6/5/2017
3.3.7.1054 1,285 6/5/2017
3.3.6.1053 1,330 4/28/2017
3.3.6.1042 1,311 4/26/2017
3.3.3.1039 1,316 3/23/2017
3.3.2.1038 1,319 3/17/2017
3.3.0.1036 1,433 2/27/2017
3.2.2.1035 1,397 1/30/2017
3.2.1.1033 1,366 12/22/2016
3.2.1.1032 1,413 12/9/2016
3.2.1.1031 1,336 11/25/2016
3.2.0.1030 1,358 10/31/2016
3.2.0.1029 1,345 10/27/2016
3.1.1.1028 1,386 9/7/2016
3.1.1.1025 1,342 8/18/2016
3.1.1.1024 1,416 8/8/2016
3.1.1.1022 1,712 7/26/2016
3.1.1.1020 1,405 6/23/2016
3.1.0.1018 1,444 5/12/2016
3.1.0.1017 1,386 5/11/2016
3.1.0.1014 1,443 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.