Use UserName Field from AspNetUsers table as primary key or populate data on a new table?

Hello, how can I set ‘UserName’ from AspNetUsers table as Primary Key instead of ‘Id’ ??

or how can I get the  ‘UserName’ automatically fills on another table with all the info and use as Primary Key to create the references that I need?

Hi MaEdCo,

Thanks for your post.

MaEdCo

how can I set ‘UserName’ from AspNetUsers table as Primary Key instead of ‘Id’ ??

I think you can remove the Primary Key directly(right-click "id") and then set the Primary Key in the field  what you want.

MaEdCo

or how can I get the  ‘UserName’ automatically fills on another table with all the info and use as Primary Key to create the references that I need?

For this,maybe you need to set relationship between these tables.

Hope this can be helpful.

Best Regards,

Eileen

thanks for your reply Eileen

Eileen ni – MSFT

I think you can remove the Primary Key directly(right-click "id") and then set the Primary Key in the field  what you want.

No I can’t delete

Eileen ni – MSFT

For this,maybe you need to set relationship between these tables.

I set the relationship a Foreing Key ,in the mean time, reference the Primary Key Id from AspNetUsers table, but I cant get that the other table fills automatically,

Leave a Reply