public async Task <List <UserViewModel> > Handle(GetAllUsersQuery request, CancellationToken cancellationToken) { //Entity Framework - Padrão CQRS //var users = _dbContext.Users; //var usersViewModel = await users.Select(u => new UserViewModel(u.Id, u.Name, u.Email)).ToListAsync(); //return usersViewModel; ////Dapper - Padrão CQRS //using (var sqlConnection = new SqlConnection(_connectionString)) //{ // sqlConnection.Open(); // var sql = "SELECT Id, Name, Email FROM Users"; // return sqlConnection.Query<UserViewModel>(sql).ToList(); //} //Padrão Repository var users = await _userRepository.GetAllAsync(); var usersViewModel = users.Select(u => new UserViewModel(u.Id, u.Name, u.Email)).ToList(); return(usersViewModel); }
public async Task <List <GetAllUsersViewModel> > Handle(GetAllUsersQuery request, CancellationToken cancellationToken) { var users = await _userRepository.GetAll(); var usersViewModel = users .Select(s => new GetAllUsersViewModel(s.Id, s.Name, new List <UserSkillViewModel>())) .ToList(); return(usersViewModel); }