ABP之PGSql
使用EntityFrameworkCore的CodeFirst方式創(chuàng)建數(shù)據(jù)庫
添加相關(guān)依賴項(xiàng)
PM> Install-Package Npgsql.EntityFrameworkCore.PostgreSQL
PM> Install-Package Npgsql.EntityFrameworkCore.PostgreSQL.Design
PM> Install-Package Microsoft.EntityFrameworkCore.Tools
Install-Package Npgsql.EntityFrameworkCore.PostgreSQL
Install-Package Npgsql.EntityFrameworkCore.PostgreSQL.Design
Install-Package Microsoft.EntityFrameworkCore.Tools
增加appsettings.json配置文件
{
"ConnectionStrings": {
"Default": "User ID=DGCore;Password=123456;Host=localhost;
Port=5432;Database=DGCore;Pooling=true;"
}
}
ABP 項(xiàng)目-DbContextConfigurer
public static class DgCorERDbContextConfigurer
{
public static void Configure(DbContextOptionsBuilder<DgCorERDbContext> builder, string connectionString)
{
//builder.UseSqlServer(connectionString);
builder.UseNpgsql(connectionString);
//options.UseNpgsql(sqlConnectionString)
}
public static void Configure(DbContextOptionsBuilder<DgCorERDbContext> builder, DbConnection connection)
{
//builder.UseSqlServer(connection);
builder.UseNpgsql(connection);
}
}
MVC項(xiàng)目 ConfigureServices
public void ConfigureServices(IServiceCollection services)
{
//獲取數(shù)據(jù)庫連接字符串
var sqlConnectionString = Configuration.GetConnectionString("Default");
//添加數(shù)據(jù)上下文
services.AddDbContext<DGCoreDbContext>(options =>
options.UseNpgsql(sqlConnectionString)
);
services.AddMvc();
}
遷移文件+更新
Add-Migration Init
Update-Database
參考
1.https://www.cnblogs.com/fonour/p/5886292.html
Asp.Net Core 項(xiàng)目實(shí)戰(zhàn)之權(quán)限管理系統(tǒng)（3） 通過EntityFramework Core使用PostgreSQL
2.(https://www.cnblogs.com/lanwilliam/p/5663931.html)
[Asp.net Core基于MVC框架實(shí)現(xiàn)PostgreSQL操作]
3.https://beigang.iteye.com/blog/1812744
PostgreSQL的用戶凰兑、角色和權(quán)限管理
4.https://www.cnblogs.com/ryanzheng/p/9575902.html
psql 工具詳細(xì)使用介紹
5.(https://www.cnblogs.com/freebird911/p/9401840.html)
[PostgreSQL 10 安裝與啟動(dòng) win10]
6
6.https://www.cnblogs.com/freebird911/p/9402652.html
Asp.NET Core2.0 EF ABP Postgresql 數(shù)據(jù)遷移
