public int Update(string sql, TEntity entity = null)
{
int cacheKey = RepositoryHelper.GetHashKey(this.ConnString, sql);
return(this.ExecSqlImpl(cacheKey, sql, CommandType.Text, entity));
}
public async Task <List <TTarget> > QueryAsync <TTarget>(string sql, TEntity objParameter = null, CommandType cmdType = CommandType.Text)
{
int cacheKey = RepositoryHelper.GetHashKey(this.ConnString, sql);
return(await this.QueryImplAsync <TTarget>(cacheKey, typeof(TTarget), sql, cmdType, objParameter));
}
public async Task <int> ExecSqlAsync(string sql, TEntity objParameter = null, CommandType cmdType = CommandType.Text)
{
int cacheKey = RepositoryHelper.GetHashKey(this.ConnString, sql);
return(await this.ExecSqlImplAsync(cacheKey, sql, cmdType, objParameter));
}
public async Task <TEntity> QueryFirstAsync(string sql, TEntity objParameter = null, CommandType cmdType = CommandType.Text)
{
int cacheKey = RepositoryHelper.GetHashKey(this.ConnString, sql);
return(await this.QueryFirstImplAsync <TEntity>(cacheKey, Mapper.EntityType, sql, cmdType, objParameter));
}
public async Task <int> UpdateAsync(string sql, TEntity entity = null)
{
int cacheKey = RepositoryHelper.GetHashKey(this.ConnString, sql);
return(await this.ExecSqlImplAsync(cacheKey, sql, CommandType.Text, entity));
}
public int ExecSql(string sql, TEntity objParameter = null, CommandType cmdType = CommandType.Text)
{
int cacheKey = RepositoryHelper.GetHashKey(this.ConnString, sql);
return(this.ExecSqlImpl(cacheKey, sql, cmdType, objParameter));
}
public List <TEntity> Query(string sql, TEntity objParameter = null, CommandType cmdType = CommandType.Text)
{
int cacheKey = RepositoryHelper.GetHashKey(this.ConnString, sql);
return(this.QueryImpl <TEntity>(cacheKey, Mapper.EntityType, sql, cmdType, objParameter));
}
public TTarget QueryFirst <TTarget>(string sql, TEntity objParameter = null, CommandType cmdType = CommandType.Text)
{
int cacheKey = RepositoryHelper.GetHashKey(this.ConnString, sql);
return(this.QueryFirstImpl <TTarget>(cacheKey, typeof(TTarget), sql, cmdType, objParameter));
}
