public static async Task <int> DeleteByIdsAsync <T>(this IDbConnection conn, object ids, IDbTransaction tran = null, int?commandTimeout = null)
{
if (CommonUtil.ObjectIsEmpty(ids))
{
return(0);
}
var builder = BuilderFactory.GetBuilder(conn);
DynamicParameters dpar = new DynamicParameters();
dpar.Add("@ids", ids);
return(await conn.ExecuteAsync(builder.GetDeleteByIdsSql <T>(), dpar, tran, commandTimeout));
}
public static async Task <IEnumerable <dynamic> > GetByIdsWithFieldDynamicAsync <T>(this IDbConnection conn, object ids, string field, string returnFields = null, IDbTransaction tran = null, int?commandTimeout = null)
{
if (CommonUtil.ObjectIsEmpty(ids))
{
return(Enumerable.Empty <dynamic>());
}
var builder = BuilderFactory.GetBuilder(conn);
DynamicParameters dpar = new DynamicParameters();
dpar.Add("@ids", ids);
return(await conn.QueryAsync(builder.GetByIdsWithFieldSql <T>(field, returnFields), dpar, tran, commandTimeout));
}
public static IEnumerable <dynamic> GetByIdsDynamic <T>(this IDbConnection conn, object ids, string returnFields = null, IDbTransaction tran = null, int?commandTimeout = null)
{
if (CommonUtil.ObjectIsEmpty(ids))
{
return(Enumerable.Empty <dynamic>());
}
var builder = BuilderFactory.GetBuilder(conn);
DynamicParameters dpar = new DynamicParameters();
dpar.Add("@ids", ids);
return(conn.Query(builder.GetByIdsSql <T>(returnFields), dpar, tran, true, commandTimeout));
}