To add an XtractQL object to the ERPConnect Services Designer, select the button with the plus (+) symbol next to XtractQLs. Specify a name for the Method and enter the XQL Statement. Select the Execute button for a preview of the data.


Select OK to confirm your entries. Save the ECS Designer file (.ecs) to initiate the code generation in the background. The generated code will be in a file named .Designer.cs (or .vb) and can be viewed in the Visual Studio editore in a file named .Designer.cs (or .vb) and can be viewed in the Visual Studio editor.

The following sample code illustrates how the XtractQL object can be used with a return table:

Click to open C# example.
using ERPConnectServices;
using System.Linq;
using(ERPConnectServicesContext context = new ERPConnectServicesContext())
    System.Data.DataTable data = context.GetMaterials();
    gv_Materials.AutoGenerateColumns = true;
    gv_Materials.DataSource = data;

When displayed in a Web Part, the results would look as shown below.


Please refer to the section XtractQL to find more samples and a complete syntax reference.