ActiveQueryBuilder.Core 3.2.0.1029

.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.2.0.1029
                    


                    

                
NuGet\Install-Package ActiveQueryBuilder.Core -Version 3.2.0.1029
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.2.0.1029" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="ActiveQueryBuilder.Core" Version="3.2.0.1029" />
                    


                            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.2.0.1029
                    


                    

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


                            Install ActiveQueryBuilder.Core as a Cake Addin
                        

                    

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


                            Install ActiveQueryBuilder.Core 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.View.WinForms

Active Query Builder 3 WinForms Components
ActiveQueryBuilder.MSSQLMetadataProvider

MSSQL Metadata Provider for Active Query Builder
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 484 13 days ago
3.13.1.2263 526 a month ago
3.13.0.2262 468 2 months ago
3.12.4.2261 672 3 months ago
3.12.3.2260 573 3 months ago
3.12.3.2259 593 3 months ago
3.12.2.2258 1,412 5 months ago
3.12.1.2257 722 6 months ago
3.12.0.2256 644 7 months ago
3.11.6.2255 1,095 8 months ago
3.11.5.2254 816 9 months ago
3.11.4.2253 831 7/7/2024
3.11.3.2252 918 4/22/2024
3.11.2.2251 1,055 3/23/2024
3.11.1.2250 846 3/22/2024
3.11.0.2249 905 3/13/2024
3.10.0.2248 1,775 12/14/2023
3.9.14.2246 1,376 12/13/2023
3.9.13.2245 1,748 9/11/2023
3.9.12.2244 2,009 5/31/2023
3.9.11.2243 2,208 5/15/2023
3.9.10.2242 2,622 4/26/2023
3.9.9.2241 2,863 4/13/2023
3.9.8.2240 3,794 3/10/2023
3.9.7.2239 15,374 2/18/2023
3.9.6.2238 4,415 1/4/2023
3.9.5.2237 6,759 10/24/2022
3.9.4.2236 6,969 9/20/2022
3.9.3.2235 7,235 9/10/2022
3.9.2.2234 7,206 8/29/2022
3.9.1.2233 7,143 8/21/2022
3.9.0.2232 8,633 7/15/2022
3.8.30.2231 6,968 7/15/2022
3.8.29.2230 7,448 7/5/2022
3.8.28.2229 7,310 7/1/2022
3.8.27.2228 7,417 6/28/2022
3.8.26.2227 7,380 6/17/2022
3.8.25.2226 6,919 6/2/2022
3.8.24.2225 8,022 5/13/2022
3.8.23.2224 7,408 5/6/2022
3.8.22.2223 7,521 4/28/2022
3.8.20.2222 8,205 4/22/2022
3.8.19.2221 7,031 4/21/2022
3.8.17.2219 7,832 2/16/2022
3.8.16.2218 7,724 1/26/2022
3.8.15.2217 5,542 1/13/2022
3.8.15.2216 5,565 1/13/2022
3.8.14.2212 4,736 12/9/2021
3.8.13.2211 4,530 12/8/2021
3.8.12.2210 5,284 11/10/2021
3.8.11.2209 16,542 11/1/2021
3.8.10.2208 5,783 9/22/2021
3.8.9.2207 5,586 8/31/2021
3.8.8.2206 5,651 8/13/2021
3.8.7.2205 5,700 7/20/2021
3.8.6.2204 5,724 7/12/2021
3.8.5.2202 5,627 6/23/2021
3.8.5.2201 5,272 6/23/2021
3.8.4.2200 5,569 6/21/2021
3.8.3.2198 5,407 6/12/2021
3.8.2.1198 5,315 5/27/2021
3.8.1.1197 5,695 5/20/2021
3.8.1.1196 5,479 5/20/2021
3.8.0.1195 5,421 5/19/2021
3.7.18.1193 5,435 3/26/2021
3.7.17.1192 5,252 3/18/2021
3.7.16.1191 5,249 3/10/2021
3.7.15.1190 5,249 3/3/2021
3.7.14.1189 5,771 2/15/2021
3.7.13.1188 5,455 2/2/2021
3.7.12.1187 5,219 1/29/2021
3.7.11.1186 5,374 1/20/2021
3.7.10.1185 5,234 1/13/2021
3.7.9.1184 5,530 1/2/2021
3.7.8.1183 5,499 12/30/2020
3.7.7.1182 5,354 12/14/2020
3.7.6.1181 5,133 11/25/2020
3.7.5.1179 5,033 10/28/2020
3.7.4.1178 4,872 10/22/2020
3.7.2.1175 5,880 9/8/2020
3.7.1.1174 5,010 8/28/2020
3.7.0.1173 5,005 8/27/2020
3.6.15.1172 3,823 8/21/2020
3.6.14.1171 3,899 8/11/2020
3.6.13.1170 3,826 8/6/2020
3.6.12.1169 3,940 8/5/2020
3.6.11.1168 3,975 8/4/2020
3.6.10.1167 3,938 7/27/2020
3.6.9.1166 3,980 7/12/2020
3.6.7.1165 4,226 7/2/2020
3.6.6.1164 4,028 6/26/2020
3.6.5.1163 3,462 6/10/2020
3.6.3.1162 4,445 6/1/2020
3.6.2.1161 4,027 5/15/2020
3.6.1.1160 4,067 5/8/2020
3.6.0.1159 4,097 4/5/2020
3.5.40.1158 3,983 3/20/2020
3.5.39.1157 4,145 3/8/2020
3.5.38.1156 3,578 2/28/2020
3.5.37.1155 3,482 2/14/2020
3.5.35.1153 4,281 1/13/2020
3.5.34.1152 4,141 12/31/2019
3.5.34.1151 4,037 12/30/2019
3.5.33.1150 3,470 12/10/2019
3.5.32.1149 5,019 11/22/2019
3.5.31.1148 3,503 11/22/2019
3.5.30.1147 3,425 11/11/2019
3.5.29.1146 3,957 11/1/2019
3.5.28.1145 4,051 10/29/2019
3.5.27.1144 4,115 10/22/2019
3.5.26.1143 3,597 10/11/2019
3.5.25.1142 3,956 10/1/2019
3.5.25.1141 3,591 9/25/2019
3.5.25.1140 4,677 8/21/2019
3.5.24.1138 4,118 8/2/2019
3.5.22.1136 3,928 7/11/2019
3.5.21.1135 4,084 6/27/2019
3.5.21.1134 4,019 6/26/2019
3.5.20.1133 4,078 6/2/2019
3.5.19.1132 3,604 5/28/2019
3.5.19.1131 3,686 5/27/2019
3.5.18.1130 4,212 5/24/2019
3.5.17.1129 3,711 5/23/2019
3.5.16.1128 3,616 5/13/2019
3.5.15.1127 4,125 4/30/2019
3.5.14.1126 4,511 4/12/2019
3.5.13.1125 4,535 3/12/2019
3.5.13.1124 4,153 3/8/2019
3.5.12.1123 6,587 2/22/2019
3.5.12.1122 6,957 2/14/2019
3.5.12.1120 7,011 2/6/2019
3.5.12.1119 6,548 2/5/2019
3.5.8.1115 6,916 12/18/2018
3.5.6.1113 6,381 11/29/2018
3.5.6.1112 6,940 11/26/2018
3.5.5.1110 6,959 11/1/2018
3.5.4.1109 6,727 10/19/2018
3.5.4.1108 6,551 10/17/2018
3.5.3.1106 7,130 9/19/2018
3.5.2.1105 7,070 9/12/2018
3.5.1.1104 6,969 9/3/2018
3.5.0.1103 6,465 8/20/2018
3.4.21.1102 6,345 8/17/2018
3.4.20.1101 6,506 7/13/2018
3.4.19.1100 7,653 7/4/2018
3.4.19.1099 7,013 6/29/2018
3.4.18.1097 7,116 6/21/2018
3.4.16.1093 6,872 5/28/2018
3.4.13.1090 7,220 5/8/2018
3.4.12.1089 6,719 5/7/2018
3.4.11.1088 7,357 4/23/2018
3.4.8.1085 7,590 4/2/2018
3.4.7.1084 8,384 3/7/2018
3.4.6.1083 6,747 3/3/2018
3.4.5.1082 7,344 2/19/2018
3.4.3.1078 6,503 1/26/2018
3.3.25.1073 6,534 12/14/2017
3.3.24.1071 6,366 11/27/2017
3.3.20.1066 6,428 9/22/2017
3.3.16.1063 6,458 8/14/2017
3.3.12.1060 6,538 7/10/2017
3.3.11.1059 6,320 6/28/2017
3.3.10.1057 6,382 6/19/2017
3.3.9.1056 6,479 6/13/2017
3.3.8.1055 6,355 6/5/2017
3.3.7.1054 2,266 6/5/2017
3.3.6.1053 6,461 4/28/2017
3.3.6.1042 6,584 4/26/2017
3.3.3.1039 6,409 3/23/2017
3.3.2.1038 6,494 3/17/2017
3.3.0.1036 6,451 2/27/2017
3.2.2.1035 6,365 1/30/2017
3.2.1.1033 6,486 12/22/2016
3.2.1.1032 2,442 12/9/2016
3.2.1.1031 2,414 11/25/2016
3.2.0.1030 2,361 10/31/2016
3.2.0.1029 2,408 10/27/2016
3.1.1.1028 2,437 9/7/2016
3.1.1.1025 2,344 8/18/2016
3.1.1.1024 2,390 8/8/2016
3.1.1.1022 2,766 7/26/2016
3.1.1.1020 2,464 6/23/2016
3.1.0.1018 2,495 5/12/2016
3.1.0.1017 2,378 5/11/2016
3.1.0.1014 2,429 5/5/2016

+ Query Transformer is now capable of renaming output query columns.
+ The new QueryTransformer.RenameDuplicatedColumns property prescribes to explicitly specify all the columns in the query SELECT list by expanding the asterisk items, then find and rename the unnamed and duplicated column names (default = false).
+ The new QueryTransformer.AlwaysExpandColumnsInQuery instructs to perform asterisk expansion in the query SELECT list even if it's not needed for the specified query transformations (default = false).
! The OutputColumn.Name property has been renamed to OriginalName.
+ The new OutputColumn.PreassignedName allows specifying the needed name for a query output column.
+ The new OutputColumn.ResultName gets the result query columns name, which turned out as a result of automatic columns renaming routine and manual appliance of the new name specified via the PreassignedName property.
- QueryTransformer: The bug with incorrect ORDER BY generation if column alias is the same as field name has been fixed.
= QueryTransformer: The new SQLGenerationOptions property has been added, the SQLBuilder property has been removed.
= The InvalidOperationException is thrown now if both MetadataItem.MetadataName and MetadataItem.MetadataObject properties are specified.
+ PostgreSQL: Support of custom aggregate functions has been made.
- MS SQL Server: CHAR and NCHAR, ROW and ROWS are added to the list of valid identifiers.
- Firebird: The simple form of the TRIM function is supported now.
- Oracle: Special form of the TRIM function is supported now.