LINQ TO DYNAMICS AX is the first offering of LINQ to the Dynamics AX ERP system. It allows for rapid integration and development against the Microsoft Dynamics Ax ERP system. Using a common code base and standard Microsoft components creating a webpage or windows application have never been so easy.
ROI, LINQ reduce the amount of time in takes to reach a stabile integration to Dynamics Ax, it thereby offers a quick return of investment. Creating the first integration is done in hours, sample movies shows just how easy it is. WHAT OUR DEMO ON HOW EASY IT IS.
TECHNICAL, LINQ to DYNAMICS AX is a new way to construct, write and read data in the .NET language of the developers’ choice. This new API simplifies working with data without having to resort to using additional language syntax like X++. LINQ to Dynamics Ax is not a replacement for any of the current class libraries; LINQ to Dynamics Ax in many cases overlaps their functionality and aims to provide a superior developer experience, but existing code will continue to work. One aspect of LINQ to Dynamics Ax is that it supports writing Query Expressions and can be combined with any of the other LINQ technologies to create or use data as a source or destination format.
VAR custTable = FROM CT IN axqp.CustTable
ORDERBY CT.Zipcode
LINQ to Dynamics Ax extends any type that inherits from IEnumerable (which is almost every collection class in .NET, from simple Arrays to List) to support query operations similar to those available in SQL. We can write queries using any of the built-in Standard Query Operators, or add our own operators if we need to. The standard operators cover a wide variety of categories, at present there are over fifty that form the backbone of LINQ. To get an idea of their scope, here is a list of those operators available to us -
| Operator Type |
Operator Name |
| Aggregation |
Aggregate, Average, Count |
| Conversion |
Cast, OfType, ToArray, ToDictionary, ToList, ToLookup, ToSequence |
| Element |
DefaultIfEmpty, ElementAt, ElementAtOrDefault, First, FirstOrDefault, Last, LastOrDefault, Single, SingleOrDefault |
| Equality |
EqualAll |
| Generation |
Empty, Range, Repeat |
| Grouping |
GroupBy |
| Joining |
GroupJoin, Join |
| Ordering |
OrderBy, ThenBy, OrderByDescending, ThenByDescending, Reverse |
| Partitioning |
Skip, SkipWhile, Take, TakeWhile |
| Quantifiers |
All, Any, Contains |
| Restriction |
Where |
| Selection |
Select, SelectMany |
| Set |
Concat, Distinct, Except, Intersect, Union |