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