public async Task <IEnumerable <Domain.Model.User> > GetAll()
{
var sql = $"SELECT Id, Name, Gender, Email, Password, CreatedOn, UpdatedOn FROM {table}";
await using var connection = new SqlConnection(_configuration.GetConnectionString("DatabaseConnection"));
connection.Open();
var users = await connection.QueryAsync <User>(sql);
return(UserEntityToUserDomainMapper.MapFrom(users));
}
public async Task <Domain.Model.User> Get(Guid id)
{
var sql = $"SELECT Id, Name, Gender, Email, Password, CreatedOn, UpdatedOn FROM {table} WHERE ID = @id";
await using var connection = new SqlConnection(_configuration.GetConnectionString("DatabaseConnection"));
connection.Open();
var dictionary = new Dictionary <string, object> {
{ "@id", id }
};
var parameters = new DynamicParameters(dictionary);
var user = await connection.QueryFirstAsync <User>(sql, parameters);
return(UserEntityToUserDomainMapper.MapFrom(user));
}
public async Task <Domain.Model.User> Get(Guid id)
{
var entity = await this._context.Users.Where(u => u.Id.Equals(id)).FirstOrDefaultAsync();
return(UserEntityToUserDomainMapper.MapFrom(entity));
}
