sunpengfei
2025-09-02 44c6adb7620d3e7ddec49a59035f094499113a6a
FlexJobApi.EntityFramework.Core/DbContexts/DefaultDbContext.cs
@@ -1,8 +1,11 @@
using FlexJobApi.Core;
using Furion;
using Furion.DatabaseAccessor;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Diagnostics;
using Microsoft.EntityFrameworkCore.Metadata.Builders;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.Options;
using System;
namespace FlexJobApi.EntityFramework.Core;
@@ -14,15 +17,23 @@
    {
    }
    public void OnCreating(ModelBuilder modelBuilder, EntityTypeBuilder entityBuilder, DbContext dbContext, Type dbContextLocator)
    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        DbUtils.OnCreating(modelBuilder, entityBuilder, dbContext, dbContextLocator);
        base.OnConfiguring(optionsBuilder);
        optionsBuilder
            .UseSqlServer(App.Configuration.GetConnectionString("FlexJobApi"), options =>
            {
                // 指定目标数据库版本为SQL Server 2014
                options.UseCompatibilityLevel(120); // 120对应SQL Server 2014
                // 可选:设置批量操作大小(按需调整)
                options.MaxBatchSize(1000);
            });
    }
    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);
        DbUtils.BuildEntityComment(modelBuilder).Wait();
        DbUtils.BuildEntity(modelBuilder).Wait();
    }
    protected override void SavingChangesEvent(DbContextEventData eventData, InterceptionResult<int> result)