Crud Operations or(Scaffold ) On MVC using Nhibernate

Crud Operations or(Scaffold ) On MVC  using Nhibernate

CREATE TABLE [dbo].[Employee](

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

      [Name] [nvarchar](255) NULL,

      [PhoneNumber] [nvarchar](255) NULL,

      [Designation] [nvarchar](255) NULL,

      [Email] [nvarchar](255) NULL,

      [DeptNo] [int] NULL,

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

/****** Object:  Table [dbo].[Department]    Script Date: 10/21/2015 17:29:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Department](

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

      [DeptName] [nvarchar](255) NULL,

      [Location] [nvarchar](255) NULL,

PRIMARY KEY CLUSTERED

(

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