public IEnumerable <T> SqlQuery <T>(string sql, object parameter) { /* * Usage: * dbContext.SqlQuery<User>("select * from Users where Id=@Id", new { Id = 1 }).ToList(); */ return(this.SqlQuery <T>(sql, PublicHelper.BuildParams(this, parameter))); }
public List <T> SqlQuery <T>(string sql, CommandType cmdType, object parameter) { /* * Usage: * dbContext.SqlQuery<User>("select * from Users where Id=@Id", CommandType.Text, new { Id = 1 }); */ return(this.SqlQuery <T>(sql, cmdType, PublicHelper.BuildParams(this, parameter))); }
public async Task <List <T> > SqlQueryAsync <T>(string sql, CommandType cmdType, object parameter) { return(await this.SqlQueryAsync <T>(sql, cmdType, PublicHelper.BuildParams(this, parameter))); }
public Task <List <T> > SqlQueryAsync <T>(string sql, object parameter) { return(this.SqlQueryAsync <T>(sql, PublicHelper.BuildParams(this, parameter))); }