using FlexJobApi.Core;
using Furion;
using Furion.DatabaseAccessor;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Diagnostics;
using Microsoft.Extensions.Configuration;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace FlexJobApi.EntityFramework.Core
{
    /// <summary>
    /// 人力资源数据库上下文
    /// </summary>
    [AppDbContext("SyncTarget", DbProvider.SqlServer)]
    public class SyncTargetDbContext : AppDbContext<SyncTargetDbContext, SyncTargetDbContextLocator>
    {
        public SyncTargetDbContext(DbContextOptions<SyncTargetDbContext> options) : base(options)
        {
        }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            base.OnConfiguring(optionsBuilder);
            optionsBuilder
                .UseSqlServer(App.Configuration.GetConnectionString("SyncTarget"), options =>
                {
                    // 指定目标数据库版本为SQL Server 2014
                    options.UseCompatibilityLevel(120); // 120对应SQL Server 2014
                                                        // 可选：设置批量操作大小（按需调整）
                    options.MaxBatchSize(1000);
                });
        }
    }
}