how can we create Database looks like as follows in
EntityFramework CodeFirst Appraoach:
Note:
I have created identity auto incremented by two and it is foreign key for all table.
How can we write FluentAPI for foreign Key and unique key?
Create Table [dbo].[UserAccount]
(
[UserID] int Identity(1,2),
[Email] nvarchar(50),
[UserName] nvarchar(50),
[Password]nvarchar(50),
Constraint [PkUserAccount] Primary Key([UserID]),
Constraint [UkEmail] Unique([Email]),
Constraint [UkUserName] Unique([UserName])
)
Go
Create Table dbo.UserPersonal
(
[UserID] int,
[Name] nvarchar(50),
[Nationality] nvarchar(50),
[Location] nvarchar(50),
[DoB] date,
[Mobile] nvarchar(50),
[Gender] bit,
Constraint [PkUserPersonal] Primary Key([UserID]),
Constraint [FrUserIDPersonal] Foreign Key([UserID]) references dbo.[UserAccount]([UserID]) on delete cascade,
Constraint [UKMobile] Unique([Mobile])
)
Go
Create Table dbo.UserProfessional
(
[UserID] int,
[Experience] Int,
[Industry] nvarchar(50),
[FunctionalArea] nvarchar(50),
[KeySkills] nvarchar(50),
[Resume] nvarchar(50),
Constraint [PkUserProfessional] Primary Key([UserID]),
Constraint [FrUserIDProfessional] Foreign Key([UserID]) references dbo.[UserAccount]([UserID]) on delete cascade,
)
GO