Entitybuilder.hasone (M => m.managerole)
. Withone ()
. Hasforeignkey<userrolemapping> (M => m.manageroleid)
. Hasprincipalkey<managerole> (R => r.id);
The following table structure will be generated
create TABLE [dbo]. [Fxkuserrolempping] ([Id] INT IDENTITY (1, 1) not NULL, [Banforumtimeend] DATETIME2 (7) is not NULL, [Banstor Etimeend] DATETIME2 (7) is not NULL, [CustomerId] int is not NULL, [Manageroleid] int is not NU
LL, [Storeroleid] INT not NULL, CONSTRAINT [pk_fxkuserrolempping] PRIMARY KEY CLUSTERED ([Id] ASC), CONSTRAINT [Fk_fxkuserrolempping_fxkmanagerole_manageroleid] FOREIGN KEY ([Manageroleid]) REFERENCES [dbo]. [Fxkmanagerole] ([Id]) on DELETE CASCADE, CONSTRAINT [Fk_fxkuserrolempping_fxkstorerole_storeroleid] FOREIGN KEY ([Storeroleid]) refer ences [dbo]. [Fxkstorerole]
([Id]) on the DELETE CASCADE); Go CREATE UNIQUE nonclustered INDEX [Ix_fxkuserrolempping_manageroleid] on [dbo]. [Fxkuserrolempping]
([Manageroleid] ASC); Go CREATE UNIQUE nonclustered INDEX [Ix_fxkuserrolempping_storeroleid] on [dbo]. [Fxkuserrolempping] ([Storeroleid] ASC);