ADO.NET Provider for Sage 200

Build 24.0.8963

Model-First Approach

This section describes how to use the Entity Data Model wizard to create the .edmx file and execute queries.

Install and Set Up Entity Framework

Install Entity Framework or add references to the required assemblies for your chosen version of Entity Framework. The assemblies are located in the lib subfolder of the installation directory. See Using EF 6 for using Entity Framework 6 (EF6). See Installed Assemblies for more information about all assemblies shipped with the provider

Add a Data Connection in Server Explorer

Before you can create an Entity Data Model, you will need to create a data connection. To do this,

  1. Navigate to Server Explorer -> right click "Data Connections" -> Add Connection...
  2. Click the Change button beside the Data Source box.
  3. Select CData Sage 200 Data Source, then click OK.
  4. Configure your connection settings, then click OK.

Add a New Item To Your Project

In the Visual Studio Solution Explorer, right-click your project and click Add > New Item.

Create an ADO.NET Entity Data Model

In the resulting Add New Item dialog, click ADO.NET Entity Data Model and enter an appropriate title, such as "Sage200EntityDataModel.edmx".

Use the Entity Data Model Wizard

Complete the following steps to create the .edmx file with the Entity Data Model wizard:

  1. On the first page, select Generate from database.
  2. On the next page, select the data provider connection you want to use with your project or create a new connection.

    Set the CacheLocation and CacheMetadata connection properties to cache table metadata. Setting these connection properties is necessary to make generating the Entity Framework model more efficient. To learn about this process, see Caching Metadata.

  3. Select whether to include sensitive data (such as passwords) in the connection string. Note that the option to exclude sensitive data means password fields are not copied to the generated config file with the rest of the connection string properties.
  4. Select the box to save the entity connection settings in App.Config, and enter a name for the context class of the data connection; for example, "Sage200Entities".

After Visual Studio retrieves the necessary information from the live data source, the wizard presents a listing of database objects you can include in your project. Note that this step may take several minutes as Visual Studio retrieves table schemas from Sage 200.

Perform LINQ Commands in Your Code

You are now ready to start using LINQ in your code.

C#

Sage200Entities context = new Sage200Entities();
var BanksQuery = from Banks in context.Banks
                   orderby Banks.Code
                   select Banks;

VB.NET

Dim context As Sage200Entities = New Sage200Entities()
Dim BanksQuery = From Banks In context.Banks 
					Order By Banks.Code
					Select Banks

Note: Be sure to declare (c#)"using System.Linq"/(VB.Net)"Imports System.Linq" in your file.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963