Biwen.EFCore.SoftDelete 1.0.0

Biwen.EFCore.SoftDelete

• 实现DbContext的软删除功能

NuGet 包

• dotnet add package Biwen.EFCore.SoftDelete --version 1.0.0

开发环境

• Windows 10
• Rider 2022 / Visual Studio 2022 / Visual Studio Code
• .NET 7.0

运行环境

• .NET 6.0
• .NET 7.0

Easy to Use

Step 1 Model定义

[PrimaryKey("Id")]
public class Blog : ISoftDeleted
{
    //...
    public int Id { get; set; }
    public string Title { get; set; } = null!;
    public string Content { get; set; } = null!;
    public int AuthorId { get; set; }

    //请注意这里的IsDeleted默认必须是false!表示未删除
    public bool IsDeleted { get; set; } = false;
}

Step 2 继承SoftDeleteDbContext

public class TestDbContext : SoftDeleteDbContext
{
	public TestDbContext(DbContextOptions<TestDbContext> options)
		: base(options)
	{
	}
    //...
	public DbSet<Blog> Blogs { get; set; }

	protected override void OnModelCreating(ModelBuilder builder)
	{
		base.OnModelCreating(builder);
		//根据情况自定义表名
        //...
	}
}

step 2 装饰器注册

var serviceProvider = new ServiceCollection()
  .AddDbContext<TestDbContext>(options =>
  {
	    //使用你的数据库引擎
      options.UseInMemoryDatabase("test");
  })
  //注册装饰器 important!
  .Decorate<TestDbContext>((ctx) => new SoftDeleteDecorator<TestDbContext>(ctx).DbContext)
  .BuildServiceProvider();

step 3 注意事项

//1. 请使用 DbSet.Remove 方法，不可使用批量删除方法:ExecuteDelete(),ExecuteDeleteAsync()

Enjoy !

License

• MIT

联系我

• QQ:552175420
• Email: vipwan#sina.com

项目地址

• [GitHub](https://github.com/vipwan)