dpper 设置一个默认数据库 和 另一个调用数据库
1: private static readonly string connectionString = ""; //System.Configuration.ConfigurationManager.AppSettings[""];
public static IDbConnection sqlServerConnection()
{
string sqlconnectionString = connectionString;
var connection = new SqlConnection(sqlconnectionString);
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
return connection;
}
//动态调用个
public static IDbConnection sqlServerConnection(string connString)
{
string sqlconnectionString = connString;
var connection = new SqlConnection(sqlconnectionString);
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
return connection;
}
2:通过NuGet包下载 Dapper
3: 使用事务主子表添加的方法。
/// <summary>
/// 订单信息同步至供应商
/// </summary>
/// <param name="PohEADER"></param>
/// <returns></returns>
public static bool InsertPOHEADER(PO_HEADER PohEADER)
{
var result = 0;
var userId = 0;
using (var db = DBHlper.sqlServerConnection())
{
using (var tran = db.BeginTransaction())
{
var insertUserActionsql = @"insert into PO_HEADER (SENDER,C