Active Query Builder for ASP.NET 3.4 has full support for ASP.NET Core 2.0+.
We're glad to announce the new version of Active Query Builder ASP.NET Edition. You can evaluate the new version by requesting the trial. Customers can download the new version in the Customer's area.
What are the major changes in the Active Query Builder ASP.NET Edition 3.4 since version 3.3?
Support for the ASP.NET Core 2.0 and .NET Standard 2.0 have been made.
Breaking change: The display of alternate names and other SQL generation options for expressions in the user interface is now determined by the QueryBuilder.SQLFormattingOptions property (rather than the QueryBuilder.SQLGenerationOptions). The QueryBuilder.SQLGenerationOptions now influences only on the query text generation returned by the QueryBuilder.SQL property.
New demo projects have been added:
The new demo for NancyFX to illustrate the definition of custom HTTP context.
New samples illustrating on-demand component loading to the MVC demo project: "Change Connection using Partial View", "Deferred Query Builder creation"; to the JavsScript Client-side rendering project: "Change Connection".
API improvements:
The new Grid.addExpression method has been added. It accepts string expression and a callback function as parameters and puts the newly created grid row as a parameter of the callback function.
Events for query object model actions have been added to the QueryBuilder object: DataSourceAdded, DataSourceFieldAdded, DataSourceFieldRemoved, LinkChanged, LinkCreated, QueryColumnListItemChanged.
New client-side events of user actions with queries on the Canvas have been added. (datasources, fields, and links: creation, changing, and removal). The complete list can be found here.
New params for the SubQuery.GetSqlForDataPreview function instruct to add a row limitation clause to the returned query. Default values prescribe not to add this clause (int skip = 0, int count = -1).
We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!
We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...
In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!