About save Uiniqidintifire type

9c28c6d9-9f56-4bb6-88f9-57312b50107d

Greetin

I usetd to Ceate user Wizard to as one step when create user profile,when admin click on continou will move to next step creat staff details which will store is staff table as a sub of parent table (Users)

picture 1:(parernt Table users)

In sub-table (Staff) I used (UserId) as forigen key see picture 2

In front-end code (SQLDATASource), I'll remodify a code in insert mode;

Question here: What a principle type to store uniqueidentifier string or integer

"UserId" Type="String" />

If I show USers table info (UserId) I see this value

9c28c6d9-9f56-4bb6-88f9-57312b50107d

it not integer jut a Nvarchar(Max)

I serached before post my question to catch a USERID to implemeint this value in detailsview load event; see that code:

using Microsoft.AspNet.Identity;
int userId = User.Identity.GetUserId<int>();

So what I do? to determine a true value, why them decleared it as integer; am lost

I can remix two table in one table if that easy, (move staff columns table to Users table), but I need them sperate.

Any suggestion?

Thanks

you are confused because perhaps you haven't gone through the microsoft documentation.

default web application uses a string value for the key for user accounts.
ASP.NET Identity enables you to change the type of the key to meet your data requirements. For example, you can change the type of the key from a string to an integer.
specify that the ApplicationUser class uses an integer for the key for user accounts

public class ApplicationUser : IdentityUser<int, CustomUserLogin, CustomUserRole,
CustomUserClaim>
{

4.You have changed the type of the key, but, by default, the rest of the application still assumes the key is a string. You must explicitly indicate the type of the key in code that assumes a string.

5.n the ApplicationUser class, change the GenerateUserIdentityAsync method to include int,

public async Task GenerateUserIdentityAsync(
UserManagerint> manager)
{
// Note the authenticationType must match the one defined in
// CookieAuthenticationOptions.AuthenticationType
var userIdentity = await manager.CreateIdentityAsync(
this, DefaultAuthenticationTypes.ApplicationCookie);
// Add custom user claims here
return userIdentity;
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
you are confused because perhaps you haven't gone through the microsoft documentation.
default web application uses a string value for the key for user accounts.
ASP.NET Identity enables you to change the type of the key to meet your data requirements. For example, you can change the type of the key from a string to an integer.
specify that the ApplicationUser class uses an integer for the key for user accounts
public class ApplicationUser : IdentityUser<int, CustomUserLogin, CustomUserRole,
    CustomUserClaim>
{
4.You have changed the type of the key, but, by default, the rest of the application still assumes the key is a string. You must explicitly indicate the type of the key in code that assumes a string.
5.n the ApplicationUser class, change the GenerateUserIdentityAsync method to include int,
public async Task GenerateUserIdentityAsync(
    UserManagerint> manager)
{
    // Note the authenticationType must match the one defined in
    // CookieAuthenticationOptions.AuthenticationType
    var userIdentity = await manager.CreateIdentityAsync(
        this, DefaultAuthenticationTypes.ApplicationCookie);
    // Add custom user claims here
    return userIdentity;
}