public async Task <Account> GetAccountByUserId(Guid userId)
{
var sql = $"SELECT Id, UserId FROM {table} WHERE UserId = @userId";
await using var connection = new SqlConnection(_configuration.GetConnectionString("DatabaseConnection"));
connection.Open();
var dictionary = new Dictionary <string, object>
{
{ "@userId", userId }
};
var parameters = new DynamicParameters(dictionary);
var account = await connection.QueryFirstAsync <FS.Data.Entities.Account>(sql, parameters);
return(AccountEntityToAccountDomainMapper.MapFrom(account));
}
public async Task <Account> Get(Guid id)
{
var entity = await this._context.Accounts.AsNoTracking().Where(u => u.Id.Equals(id)).FirstOrDefaultAsync();
return(AccountEntityToAccountDomainMapper.MapFrom(entity));
}
