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