ActiveQueryBuilder.Core 3.3.0.1036

.NET Framework This package is compatible with all versions of .NET Framework.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package ActiveQueryBuilder.Core --version 3.3.0.1036
                    


                    

                
NuGet\Install-Package ActiveQueryBuilder.Core -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.Core" 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.Core" Version="3.3.0.1036" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="ActiveQueryBuilder.Core" />
                    


                            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.Core --version 3.3.0.1036
                    


                    

                
#r "nuget: ActiveQueryBuilder.Core, 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.Core@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.Core&version=3.3.0.1036
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=ActiveQueryBuilder.Core&version=3.3.0.1036
                    


                            Install as a Cake Tool

SQL Query Parser, Analyzer and Generator for .NET (Mono-compatible) with full support of all popular database servers and appropriate SQL dialects. Active Query Builder allows for parsing of complex SQL queries for programmatic analysis and seamless modification. Active Query Builder lets prevent SQL injection attacks, deny access to unauthorized data on a row level, and get detailed information about user queries.

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.

This package has no dependencies.

NuGet packages (25)

Showing the top 5 NuGet packages that depend on ActiveQueryBuilder.Core:

Package Downloads
ActiveQueryBuilder.View.WPF

Active Query Builder 3 WPF Components
ActiveQueryBuilder.MySQLMetadataProvider

MySQL Metadata Provider for Active Query Builder
ActiveQueryBuilder.MSSQLMetadataProvider

MSSQL Metadata Provider for Active Query Builder
ActiveQueryBuilder.View.WinForms

Active Query Builder 3 WinForms Components
ActiveQueryBuilder.AdvantageMetadataProvider

Active Query Builder 3 Advantage Metadata Provider Component

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
3.13.2.2264 2,237 4/30/2025
3.13.1.2263 1,012 4/6/2025
3.13.0.2262 964 3/27/2025
3.12.4.2261 1,176 2/10/2025
3.12.3.2260 1,080 2/2/2025
3.12.3.2259 1,097 2/2/2025
3.12.2.2258 2,516 12/27/2024
3.12.1.2257 1,214 11/11/2024
3.12.0.2256 1,153 10/24/2024
3.11.6.2255 1,717 9/7/2024
3.11.5.2254 1,380 8/26/2024
3.11.4.2253 1,368 7/7/2024
3.11.3.2252 1,433 4/22/2024
3.11.2.2251 1,590 3/23/2024
3.11.1.2250 1,356 3/22/2024
3.11.0.2249 1,445 3/13/2024
3.10.0.2248 2,340 12/14/2023
3.9.14.2246 1,904 12/13/2023
3.9.13.2245 2,310 9/11/2023
3.9.12.2244 2,597 5/31/2023
3.9.11.2243 2,737 5/15/2023
3.9.10.2242 3,172 4/26/2023
3.9.9.2241 3,423 4/13/2023
3.9.8.2240 4,378 3/10/2023
3.9.7.2239 16,030 2/18/2023
3.9.6.2238 4,961 1/4/2023
3.9.5.2237 7,387 10/24/2022
3.9.4.2236 7,534 9/20/2022
3.9.3.2235 7,774 9/10/2022
3.9.2.2234 7,762 8/29/2022
3.9.1.2233 7,750 8/21/2022
3.9.0.2232 9,258 7/15/2022
3.8.30.2231 7,534 7/15/2022
3.8.29.2230 8,019 7/5/2022
3.8.28.2229 7,880 7/1/2022
3.8.27.2228 8,005 6/28/2022
3.8.26.2227 7,997 6/17/2022
3.8.25.2226 7,507 6/2/2022
3.8.24.2225 8,621 5/13/2022
3.8.23.2224 7,976 5/6/2022
3.8.22.2223 8,117 4/28/2022
3.8.20.2222 8,813 4/22/2022
3.8.19.2221 7,596 4/21/2022
3.8.17.2219 8,412 2/16/2022
3.8.16.2218 8,313 1/26/2022
3.8.15.2217 6,128 1/13/2022
3.8.15.2216 6,114 1/13/2022
3.8.14.2212 5,576 12/9/2021
3.8.13.2211 5,112 12/8/2021
3.8.12.2210 5,860 11/10/2021
3.8.11.2209 19,551 11/1/2021
3.8.10.2208 6,377 9/22/2021
3.8.9.2207 6,175 8/31/2021
3.8.8.2206 6,255 8/13/2021
3.8.7.2205 6,317 7/20/2021
3.8.6.2204 6,301 7/12/2021
3.8.5.2202 6,207 6/23/2021
3.8.5.2201 5,781 6/23/2021
3.8.4.2200 6,162 6/21/2021
3.8.3.2198 5,936 6/12/2021
3.8.2.1198 5,880 5/27/2021
3.8.1.1197 6,276 5/20/2021
3.8.1.1196 5,998 5/20/2021
3.8.0.1195 5,946 5/19/2021
3.7.18.1193 5,987 3/26/2021
3.7.17.1192 5,747 3/18/2021
3.7.16.1191 5,721 3/10/2021
3.7.15.1190 5,749 3/3/2021
3.7.14.1189 6,268 2/15/2021
3.7.13.1188 5,968 2/2/2021
3.7.12.1187 5,739 1/29/2021
3.7.11.1186 5,907 1/20/2021
3.7.10.1185 5,733 1/13/2021
3.7.9.1184 6,024 1/2/2021
3.7.8.1183 6,020 12/30/2020
3.7.7.1182 5,799 12/14/2020
3.7.6.1181 5,636 11/25/2020
3.7.5.1179 5,513 10/28/2020
3.7.4.1178 5,343 10/22/2020
3.7.2.1175 6,348 9/8/2020
3.7.1.1174 5,475 8/28/2020
3.7.0.1173 5,453 8/27/2020
3.6.15.1172 4,220 8/21/2020
3.6.14.1171 4,299 8/11/2020
3.6.13.1170 4,235 8/6/2020
3.6.12.1169 4,362 8/5/2020
3.6.11.1168 4,355 8/4/2020
3.6.10.1167 4,335 7/27/2020
3.6.9.1166 4,382 7/12/2020
3.6.7.1165 4,656 7/2/2020
3.6.6.1164 4,450 6/26/2020
3.6.5.1163 3,819 6/10/2020
3.6.3.1162 4,872 6/1/2020
3.6.2.1161 4,429 5/15/2020
3.6.1.1160 4,508 5/8/2020
3.6.0.1159 4,513 4/5/2020
3.5.40.1158 4,395 3/20/2020
3.5.39.1157 4,548 3/8/2020
3.5.38.1156 3,963 2/28/2020
3.5.37.1155 3,853 2/14/2020
3.5.35.1153 4,678 1/13/2020
3.5.34.1152 4,556 12/31/2019
3.5.34.1151 4,441 12/30/2019
3.5.33.1150 3,861 12/10/2019
3.5.32.1149 5,510 11/22/2019
3.5.31.1148 3,920 11/22/2019
3.5.30.1147 3,776 11/11/2019
3.5.29.1146 4,381 11/1/2019
3.5.28.1145 4,461 10/29/2019
3.5.27.1144 4,534 10/22/2019
3.5.26.1143 3,988 10/11/2019
3.5.25.1142 4,360 10/1/2019
3.5.25.1141 4,004 9/25/2019
3.5.25.1140 5,115 8/21/2019
3.5.24.1138 4,532 8/2/2019
3.5.22.1136 4,330 7/11/2019
3.5.21.1135 4,515 6/27/2019
3.5.21.1134 4,447 6/26/2019
3.5.20.1133 4,472 6/2/2019
3.5.19.1132 3,965 5/28/2019
3.5.19.1131 4,074 5/27/2019
3.5.18.1130 4,584 5/24/2019
3.5.17.1129 4,087 5/23/2019
3.5.16.1128 4,009 5/13/2019
3.5.15.1127 4,529 4/30/2019
3.5.14.1126 4,958 4/12/2019
3.5.13.1125 4,934 3/12/2019
3.5.13.1124 4,572 3/8/2019
3.5.12.1123 7,085 2/22/2019
3.5.12.1122 7,521 2/14/2019
3.5.12.1120 7,572 2/6/2019
3.5.12.1119 7,060 2/5/2019
3.5.8.1115 7,467 12/18/2018
3.5.6.1113 6,920 11/29/2018
3.5.6.1112 7,490 11/26/2018
3.5.5.1110 7,480 11/1/2018
3.5.4.1109 7,267 10/19/2018
3.5.4.1108 7,026 10/17/2018
3.5.3.1106 7,685 9/19/2018
3.5.2.1105 7,578 9/12/2018
3.5.1.1104 7,504 9/3/2018
3.5.0.1103 7,009 8/20/2018
3.4.21.1102 6,877 8/17/2018
3.4.20.1101 7,261 7/13/2018
3.4.19.1100 8,373 7/4/2018
3.4.19.1099 7,663 6/29/2018
3.4.18.1097 7,882 6/21/2018
3.4.16.1093 7,594 5/28/2018
3.4.13.1090 7,979 5/8/2018
3.4.12.1089 7,429 5/7/2018
3.4.11.1088 8,063 4/23/2018
3.4.8.1085 8,333 4/2/2018
3.4.7.1084 9,211 3/7/2018
3.4.6.1083 7,485 3/3/2018
3.4.5.1082 8,038 2/19/2018
3.4.3.1078 7,224 1/26/2018
3.3.25.1073 7,116 12/14/2017
3.3.24.1071 6,954 11/27/2017
3.3.20.1066 7,042 9/22/2017
3.3.16.1063 7,075 8/14/2017
3.3.12.1060 7,177 7/10/2017
3.3.11.1059 6,913 6/28/2017
3.3.10.1057 6,996 6/19/2017
3.3.9.1056 7,086 6/13/2017
3.3.8.1055 6,940 6/5/2017
3.3.7.1054 2,613 6/5/2017
3.3.6.1053 7,064 4/28/2017
3.3.6.1042 7,196 4/26/2017
3.3.3.1039 7,017 3/23/2017
3.3.2.1038 7,091 3/17/2017
3.3.0.1036 7,038 2/27/2017
3.2.2.1035 6,940 1/30/2017
3.2.1.1033 7,117 12/22/2016
3.2.1.1032 2,792 12/9/2016
3.2.1.1031 2,753 11/25/2016
3.2.0.1030 2,743 10/31/2016
3.2.0.1029 2,762 10/27/2016
3.1.1.1028 2,781 9/7/2016
3.1.1.1025 2,700 8/18/2016
3.1.1.1024 2,735 8/8/2016
3.1.1.1022 3,121 7/26/2016
3.1.1.1020 2,826 6/23/2016
3.1.0.1018 2,856 5/12/2016
3.1.0.1017 2,726 5/11/2016
3.1.0.1014 2,769 5/5/2016

+ 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.
+ 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.
+ The new SQLite metadata provider has been added.
= The Query Structure demo project has been refactored.
- Removal of unused objects from the query when the QueryBuilder.BehaviorOptions.DeleteUnusedObjects property is turned to True has been fixed.
+ IBM DB2: The ListAgg function is supported now.
+ PostgreSQL: Support of materialized view, TOAST tables and foreign tables has been made.
+ Oracle: Support of the "AT TIME ZONE" clause has been added.
+ Firebird: Column name definition after alias in the FROM clause is supported now.