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