[ROOT] / doc / DocFrag / Namespace ARCQuery

ARCQuery provides a query language that mimicks SQL but is usable through HTTP as GET URLs.

The library supports fluent query expressions and entity-relations.

Enables fluent queries like for instance
'Order/WHERE Amount > 1000 EUR/REL Customer/SKIP 100/TAKE 50/SELECT FirstName, LastName' or
'OrderLine/PIVOT Created.YearMonth() BY Product SUM Amount'

Each query consist of a series of steps, each step is a transformation of the given dataset.

The query language is supported by C# methods, defined globally or individually for each entity object class.

Supports queries and linking between entities. Understands what properties like 'Order/43/CustomerId = 42' mean.

Enables automatic suggestions in ARCAPI for adding of related entities / navigating to related entities.

Important classes in this library are:
QueryExpression,
CompoundKey (like BinaryOperatorKey, ConstantKey<T>, EntityMethodKey, NewKey, ForeignKey, MemberEntityKey),
FunctionKey,
QuantileKey and
ValueComparer (like ValueComparerDateTime).

Some online applications demonstrating ARCQuery are:
http://ARNorthwind.AgoRapide.com and
http://ARAdventureWorksOLAP.AgoRapide.com

Edit

Generated 2024-11-14 04:06:01.389 UTC