public async Task <T> SingleOrDefaultAsync <T>(string whereSql, dynamic param)
{
if (whereSql.TrimStart().ToLower().StartsWith("where", StringComparison.InvariantCulture))
{
whereSql = _SQLBuilder.BuildSelect(TypeMaper.GetTableName <T>(), TypeMaper.GetPropertiesName(typeof(T))).AppendSql(whereSql).ToSql();
}
return(await SqlMapper.QueryFirstOrDefaultAsync <T>(DBConnection, whereSql, param, DBTransaction, _Config.CommandTimeout));
}
public async Task <List <T> > BatchInsertAsync <T>(List <T> entities)
{
var type = typeof(T);
var sql = _SQLBuilder.BuildInsert(TypeMaper.GetTableName <T>(), TypeMaper.GetPropertiesName(type)).ToSql();
await this.ExecuteNonQueryAsync(sql, entities);
return(entities);
}
public async Task <T> SingleOrDefaultByIdAsync <T>(dynamic PrimaryKey)
{
var keyName = TypeMaper.GetSingleKeyName <T>();
var sql = _SQLBuilder.BuildSelect(TypeMaper.GetTableName <T>(), TypeMaper.GetPropertiesName(typeof(T))).Where().AppendColumnNameEqualsValue(keyName).ToSql();
var param = new DynamicParameters();
param.Add(Adapter.DbParmChar + keyName, PrimaryKey);
return(await SqlMapper.QuerySingleOrDefaultAsync <T>(DBConnection, sql, param, DBTransaction, _Config.CommandTimeout));
}
public async Task <List <T> > GetListAsync <T>(string whereSql, dynamic param)
{
if (whereSql.TrimStart().ToLower().StartsWith("where", StringComparison.InvariantCulture))
{
whereSql = _SQLBuilder.BuildSelect(TypeMaper.GetTableName <T>(), TypeMaper.GetPropertiesName(typeof(T))).AppendSql(whereSql).ToSql();
}
IEnumerable <T> result = await SqlMapper.QueryAsync <T>(DBConnection, whereSql, param, DBTransaction, _Config.CommandTimeout, CommandType.Text);
return(result.ToList <T>());
}
public async Task <List <T> > GetAllAsync <T>()
{
var sql = _SQLBuilder.BuildSelect(TypeMaper.GetTableName <T>(), TypeMaper.GetPropertiesName(typeof(T))).ToSql();
return((await DBConnection.QueryAsync <T>(sql, null, DBTransaction, _Config.CommandTimeout)).ToList());
}