EFCore postgresql 批量删除、插入、更新

最新推荐文章于 2025-03-27 18:55:59 发布

会飞的尼古拉斯

最新推荐文章于 2025-03-27 18:55:59 发布

阅读量1.3k

点赞数 14

分类专栏： .netCore efcore 文章标签： postgresql .netcore

本文链接：https://blog.csdn.net/weixin_43632687/article/details/142658624

版权

我用的.net 6

安装依赖包

> Microsoft.EntityFrameworkCore              6.0.33    6.0.33 
> Microsoft.EntityFrameworkCore.Tools        6.0.33    6.0.33 
> Npgsql.EntityFrameworkCore.PostgreSQL      6.0.29    6.0.29 
> Z.EntityFramework.Extensions.EFCore        6.103.4   6.103.4

添加配置

{
   
  "Logging": {
   
    "LogLevel": {
   
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "DataBaseConfig": {
   
    "Host": "192.168.214.133",
    "Port": 32222,
    "UserName": "postgresadmin",
    "Password": "admin123",
    "DataBase": "postgresdb"
  }
}

添加实体类，实体配置，以及配置类

using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;

namespace EFCoreBulkInsert
{
   
    public class Config
    {
   
        public int Port {
    get; set; }

        public string Host {
    get; set; }

        public string UserName {
    get; set; }

        public string Password {
    get; set; }

        public string DataBase {
    get; set; }
    }


    public class Test
    {
   
        public int ID {
    get; set; }

        public string Name {
    get; set; }
    }

    public class TestConfig : IEntityTypeConfiguration<Test>
    {
   
        public void Configure(EntityTypeBuilder<Test> builder)
        {
   
            builder.ToTable("test");
            builder.HasKey(t => t.ID);
            builder.Property(t

最低0.47元/天解锁文章