why there are multiple tables for roles in database?

This page summarizes the projects mentioned and recommended in the original post on /r/dotnet

Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
  • ASP.NET Core

    ASP.NET Core is a cross-platform .NET framework for building modern cloud-based web applications on Windows, Mac, or Linux.

  • so i am learning asp.net mvc and when i create a new project with individual user account authentication it creates project with database containing tables like aspnetuserroles(with userid and roleid with primary key and foreign key column), aspnetroles(which has id and roles as column) and aspnetusers(which has roles column). what i want to know is why it creates this many tables for user and why not use only roles column in aspnetuser table.

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

    WorkOS logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts