ASP.NET-MVC 实现增删改查sql数据库

CREATE DATABASE MVCLession31
GO
USE MVCLession31
GO
CREATE TABLE Dept (
    DeptId int IDENTITY(1,1) PRIMARY KEY NOT NULL,
    DeptName varchar(50)  NOT NULL
);
GO


CREATE TABLE Employee (
    EmpId int IDENTITY(1,1) PRIMARY KEY NOT NULL,
    DeptId int  NOT NULL,
    EmpName varchar(50)  NOT NULL,
    EmpPhone varchar(50)  NOT NULL,
    EmpArea varchar(50)  NOT NULL,
    EmpSalary decimal(18,2)  NOT NULL
);
GO
CREATE TABLE UserInfo
(
UserId int identity(1,1) primary key,
UserName varchar(20)not null,
PassWord varchar(20)not null
)
go
insert into UserInfo values ('admin','123456')

insert into Dept values('测试部'),('开发部'),('学习部')
insert into Employee values('1','张三','152989445511','西安','500'),('2','李四','15298944156352','宝鸡','900')
,('3','王五','15299445522','兰州','8500')