LINQ PROVIDER FOR MICROSOFT DYNAMICS AX

 

 LIVE DEMO

DOWNLOAD PRODUCTSHEET  
DEMO

PRODUCSHEET

 

 

 

Programmering og udvikling af virksomhedens DYNAMICS AX kan være en yderst kompliceret og bekostelig affære. Der stilles store krav til medarbejdernes kendskab til teknologier og deres kompetencer for at kunne håndtere en moderne virksomheds løsning.

LINQ DYNAMICS AX gør op med alt det tunge og det indviklede.

 

Med LINQ DYNAMICS AX får virksomheden mulighed for – på en ensartet metode - at arbejde med forespørgsler til DYNAMICS AX, der opsamler information i virksomheden. Dette giver helt nye adgange til virksomhedens data og forretningsprocedurer.

 

LINQ DYNAMICS AX har flere fordele. Virksomhedens ressourceforbrug reduceres væsentligt, da medarbejderen kan gå i gang med udviklingsopgaven øjeblikkeligt uden en masse tekniske udfordringer.  Og da man arbejder standardiseret, kan den enkelte medarbejder let skabe sig et overblik over igangværende udviklingsprojekter og dermed hurtigere arbejde videre på en opgave.

 

LINQ DYNAMICS AX er den lønsomme investering i integration til Dynamics AX.

 

Language Integrated Query (or LINQ, pronounced “link” for short), is a set of Microsoft® .NET technologies that provide built-in language querying functionality similar to SQL, not only for database access, but for accessing data from any source.

There is no one definition for LINQ, but it aims to solve the problem where we currently use different techniques for manipulating and selecting data from databases versus XML versus object collections; LINQ aims to make our life easier by giving us a coordinated, consistent and efficient syntax from our development environment and by using your one chosen programming language, rather than switching between programming languages.

The current LINQ family of technologies and concepts allows an extensible set of operators that work over objects, SQL data and XML data sources. The generalized architecture of the technology also allows the LINQ concepts to be expanded to almost any data domain or technology, so what LINQ is today will expand in the future.

 

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