How to: Create Data Using .NET Business Connector

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Using .NET Business Connector, you can access Microsoft Dynamics AX data or business logic from a .NET-connected application. The following example provides the code to create data in a Microsoft Dynamics AX table. For a complete working example, see Walkthrough: Integrate an Application with Microsoft Dynamics AX Using .NET Business Connector.

Procedures

Aa868997.collapse_all(en-us,AX.60).gifAdding a Reference to .NET Business Connector

This example assumes that you have a project in which you want to access Microsoft Dynamics AX data. You must create a connection using .NET Business Connector. In this section, you will add a reference to the .NET Business Connector assembly.

To add a reference to .NET Business Connector

  1. In Solution Explorer, right-click References, and then click Add Reference.

  2. In the Add Reference window, click the Browse tab.

  3. Specify the location of Microsoft.Dynamics.BusinessConnectorNet.dll, and then click Add.

    Note

    For a typical install, the assembly is located at C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin\.

  4. Click OK.

To set the project target framework

  1. In Solution Explorer, right-click your application project, and then click Properties.

  2. In the Application tab, set the Target framework to .NET Framework 4.

To update the application configuration settings

  1. In Solution Explorer, double-click the app.config file and update the following configuration settings.

    <startup useLegacyV2RuntimeActivationPolicy=”true”>
    <supportedRuntime version “v4.0” />
    
  2. On the File menu, click Save app.config.

    Note

    When you build your project, the development environment automatically creates a copy of your app.config file, changes its file name so that it has the same file name as your executable, and then moves the new .config file in the bin directory.

    If you do not update the app.config file, you will get the following error:

    “Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.”

Aa868997.collapse_all(en-us,AX.60).gifCreating a Record

In this section, you will add code to create a record in a Microsoft Dynamics AX table. You will log on to Microsoft Dynamics AX using the Axapta class. This example adds a record to the CustStatisticsGroup table called MyState.

To create a record

  1. Add a using statement to the referenced .NET Business Connector assembly.

    using Microsoft.Dynamics.BusinessConnectorNet;
    
  2. Add the following code to add a record.

    // Create the .NET Business Connector objects.
    Axapta ax;
    AxaptaRecord axRecord;
    string tableName = "CustStatisticsGroup";
    
    try
    {
        // Login to Microsoft Dynamics AX.
        ax = new Axapta();
        ax.Logon(null, null, null, null);
    
        // Create a new CustStatisticsGroup table record.
        using (axRecord = ax.CreateAxaptaRecord(tableName))
        {
            // Provide values for each of the CustStatisticsGroup record fields.
            axRecord.set_Field("CustStatisticsGroup", "04");
            axRecord.set_Field("StatGroupName", "No Priority Customer");
    
            // Commit the record to the database.
            axRecord.Insert();
        }
    }
    catch (Exception e)
    {
        Console.WriteLine("Error encountered: {0}", e.Message);
        // Take other error action as needed.
    }
    

To see the record added in the table, go to AOT > Data Dictionary > Tables, right-click CustStatisticsGroup, and then click Open. Click the green execute button to execute the SQL statement. The new No Priority Customer group is added to the table.

Next Steps

You can also read, update, and delete Microsoft Dynamics AX data. For more information, see How to: Read Data Using .NET Business Connector, How to: Update Data Using .NET Business Connector, and How to: Delete Data Using .NET Business Connector. You may want to call X++ business logic in addition to accessing data. For more information, see How to: Call Business Logic Using .NET Business Connector.

See also

Walkthrough: Integrate an Application with Microsoft Dynamics AX Using .NET Business Connector

How to: Call Business Logic Using .NET Business Connector

Axapta

AxaptaRecord

Announcements: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. Get your copy at the MS Press Store.