Using the Data Provider with the ADO.NET Entity Framework

For the latest support and certification information, visit the DataDirect Product Compatibility Guide.

The Entity Framework creates a model of your data in Visual Studio.

The following procedure assumes that you already have the database schema available.

To create a data model:

1. Create a new application, such as Windows Console, Windows Forms, or ASP.NET, in Visual Studio.

2. In the Solution Explorer, right-click the project and select Add / New Item. The Add New Item dialog box appears.

   

3. Select ADO.NET Entity Data Model, and then click Add. The Entity Data Model Wizard appears.

   

4. Select Generate from database; then, click Next. The Choose Your Data Connection window appears.

   

5. Select an established connection from the drop-down list. Alternatively, click New Connection... and do the following steps to create a new connection:
   a. On the Connection Properties window, click Change.
   b. On the Choose Data Source window, select Progress DataDirect in the Data source list; then, select your data provider in the Data provider drop-down list.
   c. Click OK.
   d. Provide the necessary connection information on the Connection Properties window, and then click OK. The Choose Your Data Connection window appears.

6. Provide additional information for your data connection.
   a. If the radio buttons are selectable, select Yes, include the sensitive data in the connection string.
   b. In the Save entity connection settings in App.Config as field, type a name for the name of the main data access class, or accept the default.
   c. Click Next. The Choose Your Database Objects window appears.

7. Select the database objects that will be used in the model; then, click Finish.

   

   The model is generated and opened in the Model Browser.

   

For more information about using the ADO.NET Entity Framework with the supported DataDirect Connect data providers, refer to the DataDirect Connect Series for ADO.NET Reference.