Table of Contents Previous Next


3 Configuring the .NET Connector : 3.5 EDBDdexProvider for Visual Studio

EDB Data Designer Extensibility Provider (EDBDdexProvider) is a component, which integrates Advanced Server database access into Visual Studio, thus providing Visual Studio integrated features.
Step 1: Install EDBDdexProvider with the EDBDdexProvider-x.x.x.vsix installer.
Step 2: Install the ADO.NET data provider EnterpriseDB.EDBClient.dll, which is a component installed as part of the EDB Postgres Connectors.
Step 3: Install EntityFramwork.EnterprisDB.EDBClient.dll, which is also a component installed as part of the EDB Postgres Connectors.
Step 4: Add the following assemblies in the global assembly cache (GAC) with the gacutil utility using the Visual Studio Developers Command line:
Step 5: Add the <DbProviderFactories> entries for the ADO.NET driver of EDB Postgres in the machine.config file. The following are the entries:
Note: For the attribute-value pairs, the double-quoted strings should not contain excess white space characters, but be configured on a single line. The examples shown in this section may be split on multiple lines for clarity, but should actually be configured within a single line such as the following:
For 64-bit Windows, the machine.config file is in the following location:
For 32-bit Windows, the machine.config file is in the following location:
Step 6: Place the DDL generation template SSDLToPgSQL.tt in the Visual Studio EntityFramework Tools\DBGen\ folder as in the following example:
Note: Select this template SSDLToPgSQL.tt in your EDMX file properties.
Step 7: Relaunch Visual Studio and verify from Tools > Extentions and Updates… menu that the EDBDdexProvider extension is installed.
Step 8: From Server Explorer, right-click on Data Connections, click Add Connection, and verify the Enterprisedb Postgres Database data source is available.
Step 9: Add files EnterpriseDB.EDBClient.dll and EntityFramework6.EnterpriseDB.EDBClient.dll in project references. See Section 3.1 for information on referencing library files.
Step 10: In the project’s app.config file add the following entry for provider services under the EntityFramework/providers tag.

3 Configuring the .NET Connector : 3.5 EDBDdexProvider for Visual Studio

Table of Contents Previous Next