转载:
https://www.cnblogs.com/yhdkzy/p/7919426.html
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.Extensions.Logging;
using Microsoft.EntityFrameworkCore.Diagnostics;
using WebMvcNetCore.TuShi.FenGong.Model;
using EntityFrameworkCore.UseRowNumberForPaging;
public class MyDbContext : DbContext
{
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
//连接字符串配置
//#connctionDb server=.;Database=gdd_tu_shi_fen_gong;uid=sa;pwd=123456
string connectionString ="server=.;Database=gdd_tu_shi_fen_gong;uid=sa;pwd=123456";
//如果是SqlServer 2008版本,则需要此设置
//EntityFrameworkCore.UseRowNumberForPaging 安装此nuget包
//using EntityFrameworkCore.UseRowNumberForPaging;
optionsBuilder.UseSqlServer(connectionString, i => i.UseRowNumberForPaging());
//设置不跟踪所有查询
optionsBuilder.UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking);
//启用敏感数据日志记录
optionsBuilder.EnableSensitiveDataLogging();
#if DEBUG
//记录日志
optionsBuilder.LogTo(msg =>
{
//调试-窗口消息
System.Diagnostics.Debug.WriteLine(msg);
//输出-窗口消息
Console.WriteLine(msg);
});
#endif
}
}