using (IDbConnection connection = new SqlConnection(_Configuration.GetConnectionString("数据库名称")))
{
connection.Open();
IDbTransaction tran = connection.BeginTransaction();
try
{
//connection.Insert<ImsMissionform_mq>(missionform, tran);//向数据库中插入ImsMissionform_mq实体
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
//connection.Insert<ImsMissionform_mq>(missionform, tran);
//_Logger.LogError(ex, $"[{ DateTimeOffset.Now:yyyy-MM-dd hh:mm:ss fffffff}] BillAnalysisService Listener Save Process Identity Failed");//记录日志
}
}
配置信息
"ConnectionStrings": {
"数据库名称": "Data Source=地址;Database=名称;uid=用户;pwd=密码;"
}