上一篇我们已经搭建好框架了,接下来做EF6实体添加
本次使用工具:sqlserver2012,visual studio2013
第一:先创建两个表,员工表,部门表,两个表设置外键关联
CREATE TABLE [dbo].[Emp](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DeptID] [int] NULL,
[EmpName] nvarchar NULL,
[EmpNum] nvarchar NULL,
[Phone] nvarchar NULL,
CONSTRAINT [PK_Emp] 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
ALTER TABLE [dbo].[Emp] WITH CHECK ADD CONSTRAINT [FK_Emp_Dept] FOREIGN KEY([DeptID])
REFERENCES [dbo].[Dept] ([ID])
GO
ALTER TABLE [dbo].[Emp] CHECK CONSTRAINT [FK_Emp_Dept]
GO
`部门表:
CREATE TABLE [dbo].[Dept](
[ID] [int] NOT NULL,
[DeptName] nvarchar NULL,
CONSTRAINT [PK_Dept] 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]
“`
结构图:
第二,添加EF实体,步骤如图
最后添加完成: