'Npgsql PostgreSQL Data Provider missing from Entity Framework 6 Data Sources

All,

I'm evaluating PostgreSQL and Npgsql as a replacement for SQL Server for an application developed by our organization. I've created a sample C# Console Application, but I'm unable to add an entity data model to the project for PostgreSQL because the .NET Data Provider is not displayed on the Data Sources dialog.

enter image description here

I've installed the Npgsql PostgreSQL Integration (v3.2.7) extension. I had also installed the latest packages for Npgsql (v4.0.2) and EntityFramework6.Npgsql (v3.2.0). I observed that this page indicates that version mismatches could cause issues, so I reverted to v3.2.7 & 3.1.1 respectively. Still no luck. Strange thing is that I do see it when attempting to establish a connection via Server Explorer.

enter image description here

Anyone have any ideas why I might not be able to see the data source when attempting to generate the entity data model? Do the selected versions not include support for VS2017? Thanks.

c++sharppostgresqlvisual-studio-2017entity-framework-6npgsql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions