Postgresql入门

下载

https://www.postgresql.org/download/ 需要FQ

使用PgAdmin

PgAdmin是访问PostgreSQL数据库的图形化工具 连接数据库 Navicat也可以连接PostgreSQL

PostgreSQL关于C#的数据驱动——Npgsql

官方资料：https://github.com/npgsql/npgsql 安装包

.net framework EntityFramework6.Npgsql https://github.com/npgsql/EntityFramework6.Npgsql .net core Npgsql.EntityFrameworkCore.PostgreSQL Microsoft.EntityFrameworkCore.Tools Microsoft.EntityFrameworkCore.Design https://github.com/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL

解决报错

The ADO.NET provider with invariant name 'Npgsql' is either not registered in the machine or application config file, or could not be loaded.

<system.data> <DbProviderFactories> <remove invariant="Npgsql" /> <add name="Npgsql Data Provider" invariant="Npgsql" description=".Net Data Provider for PostgreSQL" type="Npgsql.NpgsqlFactory, Npgsql, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" support="FF" /> </DbProviderFactories> </system.data>

参考资料：https://stackoverflow.com/questions/35425249/unable-to-find-or-load-npgsql-with-entity-frameworkhttps://github.com/npgsql/npgsql/issues/1439

示例代码

https://github.com/zLulus/NotePractice/tree/dev3/Console/CodeLibraryForDotNetCore/UsePostgresqlhttps://github.com/zLulus/NotePractice/tree/dev3/Console/CodeLibrary/UsePostgresql

参考资料

https://github.com/npgsql/EntityFramework6.Npgsqlhttp://www.npgsql.org/efcore/index.htmlhttps://docs.microsoft.com/en-us/ef/core/get-started/netcore/new-db-sqlite

转载于:https://www.cnblogs.com/Lulus/p/9726383.html

相关资源：PostgreSQL从入门到精通