CODEWITHSUNDEEP
c#entity-frameworkvisual-studiopostgresqlasp.net-core
user6347904
user6347904

Reputation:

Setup Visual Studio's Server Explorer to work with postgresql

I'm trying to setup Visual Studio's Server Explorer to connect to a postgresql database. I am using ASP.NET Core & EF Core with npgsql.

This feature works fine with SQL Server but there's no option to connect to postgresql and my attempts (including this guide) have failed. I'm using Visual Studio 2017 RC with MSBuild .NET Core, but I could downgrade to 2015 if necessary for this to work.

My aim is to be able to edit data from within VS and have a development 'localdb' similar to the one provided with SQL Server.

Upvotes: 5

Views: 7588

Answers (1)

user6347904
user6347904

Reputation:

Solved this by downloading the ODBC driver, entring my credentials, then adding it to Visual Studio through 'Add Connection'. For some reason only the 32-bit version worked (on my 64-bit machine).

Upvotes: 5

Related Questions