Skip to content

EFCore

创建时间,更新时间,删除时间

  • 当实体继承了这三个属性得时候,只有在新增才会又创建时间,如果想要也有更新时间如何处理呢？

  • 解决方式:重写 DbContext 一下方法

C#
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
namespace Lion.AbpPro.EntityFrameworkCore
{
    [ConnectionStringName("Default")]
    public class AbpProDbContext :
        AbpDbContext<AbpProDbContext>,
        IAbpProDbContext
    {
        protected override void SetCreationAuditProperties(EntityEntry entry)
        {
            SetModificationAuditProperties(entry);
            base.SetCreationAuditProperties(entry);
        }

        protected override void SetDeletionAuditProperties(EntityEntry entry)
        {
            SetModificationAuditProperties(entry);
            base.SetDeletionAuditProperties(entry);
        }
    }
}

设置数据库字符集格式

C#
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
namespace Lion.AbpPro.EntityFrameworkCore
{
    [ConnectionStringName("Default")]
    public class AbpProDbContext :
        AbpDbContext<AbpProDbContext>,
        IAbpProDbContext
    {
        protected override void OnModelCreating(ModelBuilder builder)
        {
            builder.UseCollation("utf8mb4_unicode_ci");
            builder.UseGuidCollation("utf8mb4_unicode_ci");
            base.OnModelCreating(builder);
        }
    }
}

全局设置字符串长度

  • 当数据类型是 string 时,需要给每个字段指定长度很麻烦,以下提供统一处理方式。
C#
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
namespace Lion.Pro.EntityFrameworkCore;

/// <summary>
/// ef迁移全局设置
/// </summary>
public static class LionDbContextGlobalSettingExtensions
{
    private const string Remark = "Remark";
    private const string Description = "Description";
    private const string CreationTime = "CreationTime";
    private const string IndexPrefix = "IX_Default_";

    public static void ConfigureGlobalSetting(this ModelBuilder builder)
    {
        ConfigureDefaultMaxLength(builder);
        ConfigureIndexForCreationTime(builder);
    }

    /// <summary>
    /// 配置默认字符串长度
    /// </summary>
    private static void ConfigureDefaultMaxLength(ModelBuilder builder)
    {
        var rules = ConfigureEntityMaxLengthOptions.Configure();
        // 如果是abp表不全局修改长度
        foreach (var property in builder.Model
                     .GetEntityTypes()
                     .Where(e => !e.GetTableName().StartsWith(AbpCommonDbProperties.DbTablePrefix))
                     .SelectMany(t => t.GetProperties())
                     .Where(e => e.ClrType == typeof(string)))
        {
            // 默认设置128长度
           if (property.GetMaxLength() == null)
            {
                property.SetMaxLength(128);
            }

        }
    }

    /// <summary>
    /// 创建时间添加索引
    /// </summary>
    private static void ConfigureIndexForCreationTime(ModelBuilder builder)
    {
        foreach (var property in builder.Model
                     .GetEntityTypes()
                     .Where(e => !e.GetTableName().StartsWith(AbpCommonDbProperties.DbTablePrefix))
                     .SelectMany(t => t.GetProperties())
                     .Where(e => e.Name == CreationTime))
        {
            var entityType = builder.Model.GetEntityTypes().Where(e => e.ClrType == property.DeclaringEntityType.ClrType).ToList().FirstOrDefault();
            var indexName = IndexPrefix + entityType.GetTableName() + "_" + property.Name;
            if (entityType.FindIndex(indexName) == null)
            {
                entityType?.AddIndex(property, indexName);
            }
        }
    }
}
C#
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
namespace Lion.AbpPro.EntityFrameworkCore
{
    [ConnectionStringName("Default")]
    public class AbpProDbContext :
        AbpDbContext<AbpProDbContext>,
        IAbpProDbContext
    {
        protected override void OnModelCreating(ModelBuilder builder)
        {
            builder.ConfigureGlobalSetting();
            base.OnModelCreating(builder);
        }
    }
}

如何设置 Abp 表前缀

  • 在 host 层的 Module 下修改
C#
1
2
3
4
5
6
public override void OnPreApplicationInitializatio(ApplicationInitializationContext context)
 {
     // 比如修改为带下划线
     AbpCommonDbProperties.DbTablePrefix = "Abp_";
     base.OnPreApplicationInitialization(context);
 }