MVC Complete Project With Code

Creating Cascading DropDownList In MVC 5 Using Entity Framework 6.0 Database First Step By Step 

step 1:

Create database first 

 Create database cascadingcountrystatecity;

USE [cascadingcountrystatecity]

GO

/****** Object:  Table [dbo].[C_State]    Script Date: 10/13/16 3:27:34 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[C_State](

[StId] [int] IDENTITY(1,1) NOT NULL,

[ConId] [int] NULL,

[StName] [nvarchar](100) NULL,

[DateTimeStamp] [datetime] NOT NULL,

PRIMARY KEY CLUSTERED 

(

[StId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[StName] 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

/****** Object:  Table [dbo].[City]    Script Date: 10/13/16 3:27:34 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[City](

[CityId] [int] IDENTITY(1,1) NOT NULL,

[Stid] [int] NULL,

[CityName] [nvarchar](100) NULL,

[DateTimeStamp] [datetime] NOT NULL,

PRIMARY KEY CLUSTERED 

(

[CityId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[CityName] 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

/****** Object:  Table [dbo].[country]    Script Date: 10/13/16 3:27:34 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[country](

[ConId] [int] IDENTITY(1,1) NOT NULL,

[ConName] [nvarchar](100) NULL,

[DateTimeStamp] [datetime] NOT NULL,

PRIMARY KEY CLUSTERED 

(

[ConId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[ConName] 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

/****** Object:  Table [dbo].[employee]    Script Date: 10/13/16 3:27:34 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[employee](

[Empid] [int] IDENTITY(1,1) NOT NULL,

[EmpName] [nvarchar](100) NULL,

[ConId] [int] NULL,

[StId] [int] NULL,

[CityId] [int] NULL,

PRIMARY KEY CLUSTERED 

(

[Empid] 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

ALTER TABLE [dbo].[C_State] ADD  DEFAULT (getdate()) FOR [DateTimeStamp]

GO

ALTER TABLE [dbo].[City] ADD  DEFAULT (getdate()) FOR [DateTimeStamp]

GO

ALTER TABLE [dbo].[country] ADD  DEFAULT (getdate()) FOR [DateTimeStamp]

GO

ALTER TABLE [dbo].[C_State]  WITH CHECK ADD FOREIGN KEY([ConId])

REFERENCES [dbo].[country] ([ConId])

GO

ALTER TABLE [dbo].[City]  WITH CHECK ADD FOREIGN KEY([Stid])

REFERENCES [dbo].[C_State] ([StId])

GO

ALTER TABLE [dbo].[employee]  WITH CHECK ADD FOREIGN KEY([CityId])

REFERENCES [dbo].[City] ([CityId])

GO

ALTER TABLE [dbo].[employee]  WITH CHECK ADD FOREIGN KEY([ConId])

REFERENCES [dbo].[country] ([ConId])

GO

ALTER TABLE [dbo].[employee]  WITH CHECK ADD FOREIGN KEY([StId])

REFERENCES [dbo].[C_State] ([StId])

GO

USE [master]

GO

ALTER DATABASE [cascadingcountrystatecity] SET  READ_WRITE 

GO

1: Select and copy Above Script 

2: Open sql server management studio 

3: open query window 

4: paste and execute above query :

Step 2:

1: Open visual studio 2013 and above 

2: Create web application with mvc 

3: Right click on models folder 

coming soon