Enforce case-insensitive uniqueness for the Name field in the Users table

[HappyRoot]

Hello
Currently, the Name field in the Users table allows duplicates and is case-sensitive. This can lead to data inconsistency and confusion.
Could you please add a database constraint (or modify the field) to ensure the Name field is unique and case-insensitive?

Thank you for your assistance!

[simpleidserver]

Hello,

First, I apologize for the late reply. The issue has been fixed in the master branch.
Instead of updating the EF Core configuration to add a database constraint, we chose to add the check in the repository logic.

Because SimpleIdServer supports multiple databases via EF Core, we did not want to provide SQL instructions for each type of database provider and therefore chose to limit the changes to the repository only.

Kind regards,
SID

[HappyRoot]

Thank you for the update and for the detailed explanation. I appreciate you taking the time to fix the issue.

Best regards