Make a table in sql.

Question

How to make a table using navigation property .Any Demo Query one -to- one, One to Many .Bcz i'm new in .net core ef.

Sachin Singh · Answer

copy paste below table it will generate employee and department for department list of employee will be navigation and for employee department will be navigation CREATE TABLE [dbo].[Department] ( [Id] INT IDENTITY (1, 1) NOT NULL, [Name] VARCHAR (50) NULL, CONSTRAINT [PK_Department] PRIMARY KEY CLUSTERED ([Id] ASC) ); CREATE TABLE [dbo].[Employee] ( [Id] INT IDENTITY (1, 1) NOT NULL, [Name] VARCHAR (50) NULL, [Salary] INT NULL, [DepartmentId] INT NULL, CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED ([Id] ASC), CONSTRAINT [FK_Employee_Department] FOREIGN KEY ([DepartmentId]) REFERENCES [dbo].[Department] ([Id]) ); SET IDENTITY_INSERT [dbo].[Department] ON INSERT INTO [dbo].[Department] ([Id], [Name]) VALUES (1, N 'HR' ) INSERT INTO [dbo].[Department] ([Id], [Name]) VALUES (2, N 'Development' ) INSERT INTO [dbo].[Department] ([Id], [Name]) VALUES (3, N 'Database' ) INSERT INTO [dbo].[Department] ([Id], [Name]) VALUES (4, N 'Business' ) SET IDENTITY_INSERT [dbo].[Department] OFF SET IDENTITY_INSERT [dbo].[Employee] ON INSERT INTO [dbo].[Employee] ([Id], [Name], [Salary], [DepartmentId]) VALUES (1, N 'sachin' , 100000, 1) INSERT INTO [dbo].[Employee] ([Id], [Name], [Salary], [DepartmentId]) VALUES (2, N 'arjun' , 23000, 1) INSERT INTO [dbo].[Employee] ([Id], [Name], [Salary], [DepartmentId]) VALUES (3, N 'vikash' , 30000, 2) INSERT INTO [dbo].[Employee] ([Id], [Name], [Salary], [DepartmentId]) VALUES (4, N 'pocha' , 43000, 3) INSERT INTO [dbo].[Employee] ([Id], [Name], [Salary], [DepartmentId]) VALUES (5, N 'Nivedita' , 24000, 4) SET IDENTITY_INSERT [dbo].[Employee] OFF

Guest User · Answer

Sir Demo query Table.

Sachin Singh · Answer

use appropriate foreign keys in table and EF will generate corresponding Navigation properties automatically , you don't need to worry for that. I hope you are asking about database first approach and not code first approach.