Add middle_name field to Users table

[HappyRoot]

Hello,

Could we please add an optional middle_name column to the Users table and include it in the corresponding entity property?

[simpleidserver]

Hello,

The middle name has been added to the user table, and the migration scripts have been updated 🙂.
These changes are already available in the release/v6.0.4 branch.
The administration website has also been updated to display this new field.

Kind regards,
SID

[HappyRoot]

Hello,

After updating to version 6.04, a problem occurs when Middlename is not provided.

Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware[1]
An unhandled exception occurred while executing the request.
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
---> Npgsql.PostgresException (0x80004005): 23502: NULL value in column "Value" of relation "UserClaims" violates NOT NULL constraint

Additional Problem:
There's also an issue with FirstName - the user update request doesn't include a FirstName field, and the Name field from the request now updates the Name field in the database entity instead.

Thank you to the whole team for your work on this project!

[simpleidserver]

Hello,

My apologies — the issue has already been fixed in the master branch. Can-you fetch the branch master & try again?

Kind regards,
SID

[HappyRoot]

Hello,

Thank you for the hard work on the recent 6.05 release. We've noticed that the middlename field is working well for updates, which is excellent.

However, we currently cannot assign a middlename when creating a new user during the registration process. To maintain complete and accurate user records from the start, would it be possible to add the middlename field to the registration workflow?

To help with this, I have already created a pull request that implements this feature:
#923

Thanks again for your support.

Sincerely,
Happy.