public IEnumerable <GetAllTeamsQueryDataAccessOutput> Query() { using (var connection = _dataService.GetSqlConnection()) { var query = "select Id, Name, CreateSharePointSite, CreateTeamsChannel from Teams"; return(connection.Query <GetAllTeamsQueryDataAccessOutput>(query)); } }
public GetTeamQueryDataAccessOutput Query(Guid id) { using (var connection = _dataService.GetSqlConnection()) { var query = "select Name, Description, CreateSharePointSite, CreateTeamsChannel from Teams where Id = @Id"; var parameters = new DynamicParameters(new { Id = id }); return(connection.QueryFirstOrDefault <GetTeamQueryDataAccessOutput>(query, parameters)); } }