Creating Tables and Retrieving Query results with Dynamics AX 2009 business connector

Posted by namenlos on Stack Overflow See other posts from Stack Overflow or by namenlos
Published on 2010-04-05T01:48:01Z Indexed on 2010/04/05 1:53 UTC
Read the original article Hit count: 858

Filed under:

dynamics-ax

|

dynamics-ax-2009

|

c#

|

microsoft-dynamics

I'm writing a C# command line tool to fetch data from AX and to add data (create new tables) to AX.

Fetching data from an AX table is easy and documented here: http://msdn.microsoft.com/en-us/library/cc197126.aspx

Adding data to an existing table is also easy: http://msdn.microsoft.com/en-us/library/aa868997.aspx

But I cannot figure out how to do two things:

Create a new AX Table
Retrieve data from an AX Query

Can someone please share some sample code or give some pointers on where to start looking. My searches on Google and MSDN have not revealed much.

NOTE: I am not an experienced AX or ERP developer.

© Stack Overflow or respective owner

Related posts about dynamics-ax

Using Dynamics AX's Business Conectors to Generate Sales Orders

as seen on Stack Overflow - Search for 'Stack Overflow'
So, just like the title says, I need to create an application that gets data from another Database, and shoves it through Dynamics AX's throat. This data comes from a portal, not Enterprise Portal, but a PHP one. It stores some data from the order in a separate database. So as said, I need to 'import'… >>> More
Problems connecting to MS Dynamics AX 2009 Application Object Server

as seen on Server Fault - Search for 'Server Fault'
I've got a funny problem connecting to an AOS server. I got a domain network containing a (VM) Server running the Application Object Server (AOS). Client computer A) can connect to the AOS without problems and work. When client computer B) tries to connect, all I get is this error message: Logon… >>> More
Dynamics AX 2009 Visual Studio Template Files

as seen on Stack Overflow - Search for 'Stack Overflow'
Where online can I download the Visual Studio template files for Microsoft Dynamics AX 2009? >>> More
Creating Tables and Retrieving Query results with Dynamics AX 2009 business connector

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm writing a C# command line tool to fetch data from AX and to add data (create new tables) to AX. Fetching data from an AX table is easy and documented here: http://msdn.microsoft.com/en-us/library/cc197126.aspx Adding data to an existing table is also easy: http://msdn.microsoft.com/en-us/library/aa868997… >>> More
Examples of Dynamics AX 2009 programming?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm just learning to program Dynamics AX 2009. So far I got the dev system running, I got some background about the architecture. Now I'm looking for some walkthrough-samples to learn more about programming in this system. Are there some samples available online? Can someone point me to some learning… >>> More

Related posts about dynamics-ax-2009

Creating Tables and Retrieving Query results with Dynamics AX 2009 business connector

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm writing a C# command line tool to fetch data from AX and to add data (create new tables) to AX. Fetching data from an AX table is easy and documented here: http://msdn.microsoft.com/en-us/library/cc197126.aspx Adding data to an existing table is also easy: http://msdn.microsoft.com/en-us/library/aa868997… >>> More
Problems connecting to MS Dynamics AX 2009 Application Object Server

as seen on Server Fault - Search for 'Server Fault'
I've got a funny problem connecting to an AOS server. I got a domain network containing a (VM) Server running the Application Object Server (AOS). Client computer A) can connect to the AOS without problems and work. When client computer B) tries to connect, all I get is this error message: Logon… >>> More
Dynamics AX 2009 Visual Studio Template Files

as seen on Stack Overflow - Search for 'Stack Overflow'
Where online can I download the Visual Studio template files for Microsoft Dynamics AX 2009? >>> More
Examples of Dynamics AX 2009 programming?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm just learning to program Dynamics AX 2009. So far I got the dev system running, I got some background about the architecture. Now I'm looking for some walkthrough-samples to learn more about programming in this system. Are there some samples available online? Can someone point me to some learning… >>> More
In Dynamics AX, using the Business Connector, how do you call kernel functions?

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to know you can call kernel functions in from AX using C# (.Net Business Connector). Specifically, can you call methods like fieldName2Id, tableName2Id and curUserId? >>> More