Loading

Adding a column to AspNetUserRoles table in MVC

Blumonde

10y2.2k.NET

Hello,

Out-of-the-box AspNetUserRoles table comes with 2 columns. I added another column called "grpId" to the table manually via SQLMS.

And now, my application doesn't show this column via intellisense when accessing its properties. What more do I need to do in order to get my app to show this column? Please help.

Thank you.

1 Reply

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

Nitin Sontakke10y ago
There is nothing special about tables come with role management. Technically, you should see it.
However, personally, i would strongly recommend not to add columns to their tables. The best approach (I think) is to create a separate table with one-to-one relationship sharing the same primary key and have any additional columns you want in this new table. This way the whole thing remain fully abstracted.
The stored procedures where SELECT is performed, left out join this custom (extended) table.
0