Adding a column to AspNetUserRoles table in MVC

Question

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.

Nitin Sontakke · Answer

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.