配置实体外键，使用IEntityTypeConfiguration时，外键没有生效

[LucasYao93]

使用IEntityTypeConfiguration配置实体表的外键信息，迁移日志没有包含外键创建信息, 对应的表也没有生成外键。

public  class EPAMSDbContext : DbContext
{
    #region 配置表
    public virtual DbSet<Device> Devices { get; set; }

    public virtual DbSet<Communication> Communications { get; set; }

    public virtual DbSet<DeviceGroup> DeviceGroups { get; set; }

    public virtual DbSet<TestPoint> TestPoints { get; set; }

    #endregion
    public virtual DbSet<User> Users { get; set; }


    private readonly IFreeSql _freesql;
    public EPAMSDbContext()
    {
    }

    public EPAMSDbContext(IFreeSql freeSql)
    {
        _freesql = freeSql;
    }

    protected override void OnConfiguring(DbContextOptionsBuilder builder)
    {
        // iFreesql.xxxx
        // 使用 iFreesql 调用 Fluent api
        builder.UseFreeSql(_freesql);
    }

    protected override void OnModelCreating(ICodeFirst codefirst)
    {

    }
}
//Device表配置
public class DevcieTableConfiguarion : IEntityTypeConfiguration<Device>
{
    public void Configure(EfCoreTableFluent<Device> device)
    {
        device.ToTable(nameof(Device));
        device.HasIndex(d => d.CommunicationId).HasName($"idx_{nameof(Device.CommunicationId)}");
        device.HasIndex(d => d.DeviceGroupId).HasName($"idx_{nameof(Device.DeviceGroupId)}");
        device.HasOne(d => d.Communication).HasForeignKey(d => d.CommunicationId).WithMany(c => c.Devices);
    }
}
//Communication配置
public class CommunicationTableConfiguarion : IEntityTypeConfiguration<Communication>
{
    public void Configure(EfCoreTableFluent<Communication> communication)
    {
        communication.ToTable(nameof(Communication));
        communication.HasMany(c => c.Devices).WithOne(d => d.Communication).HasForeignKey(d => d.CommunicationId);
    }
}

 public static IServiceCollection AddAppDbContext<T>(this IServiceCollection services, [NotNull] string connectionString) where T : DbContext
 {
     if (string.IsNullOrWhiteSpace(connectionString))
     {
         throw new ArgumentNullException(nameof(connectionString), "The db connection string is null.");
     }

     IFreeSql fsql = new FreeSql.FreeSqlBuilder()
     .UseConnectionString(FreeSql.DataType.MySql, @$"{connectionString}")
     .CreateDatabaseIfNotExists()
     .Build();

     //禁用自动同步表结构
     fsql.CodeFirst.IsAutoSyncStructure = false;

     fsql.CodeFirst.ApplyConfigurationsFromAssembly(typeof(DevcieTableConfiguarion).Assembly);

     //fsql.CodeFirst.IsLazyLoading = true;
     services.AddSingleton<IFreeSql>(fsql);
     services.AddFreeDbContext<T>(options => options.UseFreeSql(fsql));

     return services;
 }

public class DBManagerService : DBManager.DBManagerBase
{
   private readonly IFreeSql _freeSql;
   private readonly ILogger<DBManagerService> _logger;
   public DBManagerService(
       ILogger<DBManagerService> logger, 
       IFreeSql freeSql)
   {
       _logger = logger;
       _freeSql = freeSql;
   }

 //获取迁移日志
   public override Task<MigrationResult> GetMigrateLog(Empty request, ServerCallContext context)
   {
       SystemGlobalParam.IsGetMigrateLog = false;

       var log = _freeSql.CodeFirst.GetComparisonDDLStatements(DbContextExtensions.GetTypesBbContext(typeof(EPAMSDbContext)).ToArray()) 
                   ?? "No table structure changes";

       _logger.LogInformation(log);

       var response = new MigrationResult()
       {
           IsOk = true,
           Message = log,
       };

       SystemGlobalParam.IsGetMigrateLog = true;

       return Task.FromResult(response);
   }
//迁移数据库
   public override Task<MigrationResult> Migrate(Empty request, ServerCallContext context)
   {
       if (!SystemGlobalParam.IsGetMigrateLog)
       {
           throw new Exception("Please obtain the migration log first and check it.");
       }
       _freeSql.CodeFirst.SyncStructure(DbContextExtensions.GetTypesBbContext(typeof(EPAMSDbContext)).ToArray());
       
       var result = new  MigrationResult() { 
           IsOk = true , 
           Message = "Successfull Migrated."
       };

       SystemGlobalParam.IsGetMigrateLog = false;

       return Task.FromResult(result);
   }
}

数据库版本

| version | 5.7.13
| version_comment | MySQL Community Server (GPL)
| version_compile_machine | x86_64
| version_compile_os | Win64

安装的Nuget包

.net framework/. net core？ 及具体版本

.Net 6

[LucasYao93]

不支持迁移外键。