SqlSugar ORM已经支持读写分离

using (var db = new SqlSugarClient("主连接字符串", "从连接字符串","可以多个从连接"))
{
  var list= db.Queryable<Student>().ToList();//走从
  var list= db.Queryable<Student>().ToJson();//走从
  db.Insert(new Student() { name="写入" });//走主
  db.Delete(new Student() {id=1 });//走主
  db.BeginTran //事务内操作都是主
   
   
}

/// <summary>

/// 初始化 SqlSugarClient 类的新实例（主从模式）
/// </summary>
/// <param name="masterConnectionString">主:写入事务等操作</param>
/// <param name="slaveConnectionString">从:无事务读取</param>
public SqlSugarClient(string masterConnectionString,params string [] slaveConnectionString)
    : base(masterConnectionString, slaveConnectionString)
{
    ConnectionString = masterConnectionString;
}