private static ApplicationUser ReadApplicationUser(SqlDataReader reader) { var idx = 0; var id = reader.AsString(idx++); var firstName = reader.AsStringOrNull(idx++); var lastName = reader.AsStringOrNull(idx++); // var personalNumber = reader.AsStringOrNull(idx++); var country = reader.AsStringOrNull(idx++); var city = reader.AsStringOrNull(idx++); var address = reader.AsStringOrNull(idx++); var emailConfirmed = reader.AsBoolean(idx++); // var identificationNumber = reader.AsStringOrNull(idx++); var email = reader.AsString(idx++); var cratedAt = reader.AsDateTime(idx++); var dateOfBirth = reader.AsDateTimeOrNull(idx++); var refreshToken = reader.AsJsonOrNull <RefreshToken>(idx); return(new ApplicationUser() { Id = id, FirstName = firstName, LastName = lastName, //PersonalNumber = personalNumber, Country = country, City = city, Address = address, EmailConfirmed = emailConfirmed, //IdentificationNumber = identificationNumber, Email = email, CreatedAt = cratedAt, DateOfBirth = dateOfBirth, RefreshToken = refreshToken }); }