[help IN sql] Need to bulk insert users with sql, need to fill the securitystamp and concurrency stamp

[riaadh]

IdentityServer version

latest

.NET version

8

Description

Hello,
I need to import a legacy database to aspnetuser in identity server and i must do it in sql.

from what i see in the code i need to reproduce this codes in SQL

 public IdentityUser()
 {
     Id = Guid.NewGuid().ToString();
     SecurityStamp = Guid.NewGuid().ToString();
 }

so for the id i think this code in sql will work lower(NEWID())
but unfortunatrly the guid for the security stamp is overrided by this (intentionally or not i dont know) :

`        private static string NewSecurityStamp()
        {
            byte[] bytes = new byte[20];
#if NETSTANDARD2_0 || NET461
            _rng.GetBytes(bytes);
#else
            RandomNumberGenerator.Fill(bytes);
#endif
            return Base32.ToBase32(bytes);
        }`

could you tell me why it is not a simple GUID?
and can you help me transform it in sql

i tried this CONVERT (CHAR(32) , CRYPT_GEN_RANDOM(20)) but it does not generate base32 string

thanks a lot for your help

Reproduction steps

No response

Expected behavior

No response

Logs

No response

Additional context

No response

[RolandGuijt]

Allthough we use ASP.NET Core Identity in our templates to show how to do user management, it is not part of our products. It is maintained by Microsoft. So probably their issue tracker is a better place to ask this question.

Here's what I know about the topic though:
SecurityStamp in ASP.NET Core Identity is a random value associated with a user that is changed by Identity whenever the user's credentials change, such as when a password is modified or a login is removed.
It helps with invalidating the session and it is also used to generate tokens for email confirmation and password reset e.g.
It is a random value. Don't know why it's not a GUID but there are many extension points you could explore to see if you can change the default behavior.