I’m using .NET Core with MinimalAPI and EntityFramework 8 for a personal project. To manage registration and login, I’ve used Identity Management out of the box. Now, I need to add some additional information about the relationship between users and roles without resorting to a custom table, but unfortunately, I haven’t been able to find documentation on this.

In short, the UsersRole entity should transition from:

CREATE TABLE [dbo].[UsersRoles](
    UserId nvarchar(450) NOT NULL,
    RoleId nvarchar(450) NOT NULL,
)

to:

CREATE TABLE [dbo].[UsersRoles](
    UserId nvarchar(450) NOT NULL,
    RoleId nvarchar(450) NOT NULL,
    CustomField1 nvarchar(450) NOT NULL,
    CustomField2 nvarchar(450) NOT NULL
)

Would anyone be able to assist me in handling this scenario?
Thank you in advance.