ASP.NET MVC dropdown STORE IN DB

Hi Bala S,

Yes it is possible you can save data in db if the tables does not have any relations between them.

Consider below example I have create three tables tb_A ,tb_B and tb_C and i want to save data of tb_A and tb_B in tb_C. I don't give any foreign key relationship between these tables(Just give the column name so that we can identify that this data is from which table) and at the time of insertion just passing the Id's into A_Id and B_Id.

Hope it will help you..

CREATE TABLE [dbo].[tb_A](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NOT NULL,
CONSTRAINT [PK_tb_A] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_B](
[B_Id] [int] NOT NULL,
[Password] [varchar](50) NOT NULL,
CONSTRAINT [PK_tb_B] PRIMARY KEY CLUSTERED
(
[B_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[tb_C](
[C_Id] [int] IDENTITY(1,1) NOT NULL,
[Address] [varchar](50) NOT NULL,
[A_Id] [int] NOT NULL,
[B_Id] [int] NOT NULL,
CONSTRAINT [PK_tb_C] PRIMARY KEY CLUSTERED
(
[C_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Hiten Pandya8y ago
Hi Bala S,

Yes it is possible you can save data in db if the tables does not have any relations between them.

Consider below example I have create three tables tb_A ,tb_B and tb_C and i want to save data of tb_A and tb_B in tb_C. I don't give any foreign key relationship between these tables(Just give the column name so that we can identify that this data is from which table) and at the time of insertion just passing the Id's into A_Id and B_Id.

Hope it will help you..
CREATE TABLE [dbo].[tb_A](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [Name] [varchar](50) NOT NULL,
CONSTRAINT [PK_tb_A] PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_B](
    [B_Id] [int] NOT NULL,
    [Password] [varchar](50) NOT NULL,
CONSTRAINT [PK_tb_B] PRIMARY KEY CLUSTERED
(
    [B_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[tb_C](
    [C_Id] [int] IDENTITY(1,1) NOT NULL,
    [Address] [varchar](50) NOT NULL,
    [A_Id] [int] NOT NULL,
    [B_Id] [int] NOT NULL,
CONSTRAINT [PK_tb_C] PRIMARY KEY CLUSTERED
(
    [C_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
+1