Entity freamwork 6 Connect to PostgreSQL database

Original Entity freamwork 6 connect PostgreSQL database

Development environment

VS. Update 1 postgre Sql 9.4

Use procedure

1. Use NuGet to add references to Entityframework6.npgsql in your project

2. Download and install the Npgsqlddexprovider program,: https://github.com/npgsql/npgsql/releases , please download EXE file, he will help you do a lot of things. After the download is complete, close vs, install the downloaded files, after the installation is complete, click on the Tools (tool) in VS, then click Setup Npgsql dbproviderfactories, point two ok.

If you encounter problems, please refer to the official instructions: http://www.npgsql.org/doc/ddex.html

4. When you go to the new EF's ADO Data model, you can choose Postgre SQL database directly.

5. Then use it as SQL Server.

Entity freamwork 6 Connect to PostgreSQL database