public static int InsertList <T>(this IDbConnection db, IEnumerable <T> entitys, IDbTransaction trans = null, int?commandTimeout = null)
{
if (!entitys.Any())
{
return(0);
}
var sqllam = new SqlExp <T>(db.GetAdapter());
sqllam = sqllam.Insert();
var sqlString = sqllam.SqlString;
try
{
DebuggingSqlString(sqlString);
return(db.Execute(sqlString, entitys, trans, commandTimeout, CommandType.Text));
}
catch (Exception ex)
{
DebuggingException(ex, sqlString);
throw new DapperLamException(ex.Message, ex, sqlString)
{
Parameters = sqllam.Parameters
};
}
}
public static int Insert <T>(this IDbConnection db, T entity, IDbTransaction trans = null, int?commandTimeout = null)
{
var sqllam = new SqlExp <T>(db.GetAdapter());
sqllam = sqllam.Insert();
try
{
return(db.Execute(sqllam.SqlString, entity, trans, commandTimeout, CommandType.Text));
}
catch (Exception ex)
{
if (Debugger.IsAttached)
{
Debug.WriteLine(ex.Message + ex.StackTrace);
Debug.WriteLine(sqllam.SqlString);
}
Console.WriteLine(ex.Message + ex.StackTrace);
Console.WriteLine(sqllam.SqlString);
throw new DapperLamException(ex.Message, ex, sqllam.SqlString)
{
Parameters = sqllam.Parameters
};
}
}
public static int Insert(this IDbConnection db, SqlTableDefine tableDefine, List <SqlColumnDefine> columnDefines, IEnumerable <object> entity, IDbTransaction trans = null, int?commandTimeout = null)
{
var sqllam = new SqlExp <object>(tableDefine, columnDefines, db.GetAdapter());
sqllam = sqllam.Insert(tableDefine, columnDefines);
var sqlString = sqllam.SqlString;
try
{
DebuggingSqlString(sqlString);
return(db.Execute(sqlString, entity, trans, commandTimeout, CommandType.Text));
}
catch (Exception ex)
{
DebuggingException(ex, sqlString);
throw new DapperLamException(ex.Message, ex, sqlString)
{
Parameters = sqllam.Parameters
};
}
}
public static Task <int> InsertAsync <T>(this IDbConnection db, T entity, IDbTransaction trans = null,
int?commandTimeout = null)
{
var sqllam = new SqlExp <T>(db.GetAdapter());
sqllam = sqllam.Insert();
var sqlString = sqllam.SqlString;
try
{
DebuggingSqlString(sqlString);
return(db.ExecuteAsync(sqlString, entity, trans, commandTimeout, CommandType.Text));
}
catch (Exception ex)
{
DebuggingException(ex, sqlString);
throw new DapperLamException(ex.Message, ex, sqlString)
{
Parameters = sqllam.Parameters
};
}
}
