1

I am trying to create a utility for AX 2012 in visual studio using .net interop to X++ and proxy classes, I've added necessary tables in my project, I can access tables individually and can loop them through .next() method, but I want to join these tables so I can get my desired results (I want to display a grid with item id, name alias, color, size information).

I am unable to figure out how to join InventTable, InventDim andInventDimCombination` for this purpose. Can you guys please tell me how can I join AOT tables without having to use traditional .net business connector methods in visual studio?

Jan B. Kjeldsen
  • 17,817
  • 5
  • 32
  • 50
alphaprolix
  • 601
  • 2
  • 10
  • 25

1 Answers1

1

Upgrade to AX 2012 R2. Then use LINQ. A code example.

Update:

If not possible, then create an AX query, either in AX or programmaticly from .Net. Then use the query the get the AX records. A working example.

Or use the AX 2012 AIF Query AIF Web Service.

Jan B. Kjeldsen
  • 17,817
  • 5
  • 32
  • 50
  • thanks Jan for replying, currently it is not possible for us to upgrade to R2, is there any other way to accomplish it ? there has to be a way for such a basic operation, if we can access tables in VS why cant we join them ? – alphaprolix Dec 07 '12 at 14:11