Ahmed Adel

Ahmed Adel

  • NA
  • 6
  • 829

SQL Server Database construction with ASP Identity

Nov 18 2017 9:51 AM
I'm trying to build a database where I'm having about 3 roles, each of these roles have some common attributes like username, mail, password. Also each role has some special attributes, also each attribute is related to different tables in ERD Diagram. When I'm using ASP MVC Identity, I have only 1 table for users AspNetUsers
 
Is it right (good approach) to put all the entities in the users table and connect it to all the tables which each role is connected to ??
 
Also please if anyone have any website where I can see some big SQL Server databases Implemented with ASP Identity so I can check the best way to implement databases (I searched and found none till now)
 
Thanks a lot