Install EDBDdexProvider with the EDBDdexProvider.vsix
installer at the following location:
Add the following assemblies in the global assembly cache (GAC) with the gacutil
utility using the Visual Studio Developers Command line:
Add the <DbProviderFactories>
entries for the ADO.NET driver of EDB Postgres in the machine.config
file. The following are the entries:
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:
Relaunch Visual Studio and verify from Tools > Extentions and Updates
… menu that the EDBDdexProvider extension is installed.
From Server Explorer, right-click on Data Connections
, click Add Connection
, and verify the Enterprisedb Postgres Database
data source is available.
Place the DDL generation template SSDLToPgSQL.tt
in the Visual Studio EntityFramework Tools\DBGen\
folder as in the following example:
Select this template SSDLToPgSQL.tt
in your EDMX file properties.
Add files EnterpriseDB.EDBClient.dll
in project references. See Section 3.1
for information on referencing library files.
In the project’s app.config
file add the following entry for provider services under the EntityFramework/providers tag.