public async Task <IEnumerable <CredentialTypeDto> > HandleAsync(CredentialTypeListQuery query, CancellationToken cancellationToken = default(CancellationToken)) { var types = await _db.CredentialTypes .Select(e => new CredentialTypeDto { Id = e.Id, Code = e.Code, Name = e.Name } ).AsNoTracking().ToListAsync(); return(types); }
public async Task <IEnumerable <CredentialTypeDto> > HandleAsync(CredentialTypeListQuery query, CancellationToken cancellationToken = default(CancellationToken)) { using (var conn = new SqlConnection(_configuration.HouseholdConnectionString)) { await conn.OpenAsync(cancellationToken); var types = await conn.QueryAsync <CredentialTypeDto>(@" SELECT Id, Code, Name, Description, Address_Street AS Street, Address_City AS City, Address_Country AS Country, Address_ZipCode AS ZipCode, Version FROM Households WHERE UserId = @UserId "); return(types); } }