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)));
}
