About save Uiniqidintifire type

Question

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

Sachin Singh · Answer

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( UserManager int > 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; }