net5中如何添加两个SqlSugarClient
在.NET 5中,可以通过以下方式添加两个SqlSugarClient:
- 创建一个新的SqlSugarClient实例:
var client2 = new SqlSugarClient(new ConnectionConfig()
{
ConnectionString = "connection string 2",
DbType = DbType.SqlServer,
IsAutoCloseConnection = true,
InitKeyType = InitKeyType.Attribute
});
- 修改默认SqlSugarClient实例的连接字符串:
SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()
{
ConnectionString = "connection string 1",
DbType = DbType.SqlServer,
IsAutoCloseConnection = true,
InitKeyType = InitKeyType.Attribute
});
// 修改默认SqlSugarClient实例的连接字符串
db.Ado.ConnectionString = "connection string 2";
注意:在使用多个SqlSugarClient实例时,需要确保每个实例的连接字符串和数据库配置正确,否则会出现连接失败等问题
原文地址: https://www.cveoy.top/t/topic/hhGh 著作权归作者所有。请勿转载和采集!