首页 > 其他 > 详细

EF实现主从表自动生成主键保存

时间:2016-02-18 11:35:13      阅读:204      评论:0      收藏:0      [点我收藏+]
   Class cl = new Class() {   ClassName = "一年级1班" };
               
                TestDBEntities context = new TestDBEntities();
                context.Class.Add(cl);
                

                Student st = new Student() { Class = cl,  Name="wangxiaoming" };
                context.Student.Add(st);
                context.SaveChanges();

下面给出数据库关系图

技术分享

对应sql脚本:

CREATE TABLE [dbo].[Class](
[ClassID] [int] IDENTITY(1,1) NOT NULL,
[ClassName] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Class] PRIMARY KEY CLUSTERED 
(
[ClassID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

 


CREATE
TABLE [dbo].[Student]( [StudentID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](50) NOT NULL, [ClassID] [int] NOT NULL, CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED ( [StudentID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]

设置class和student的主键和student的外键,并且主键为自增。

EF实现主从表自动生成主键保存

原文:http://www.cnblogs.com/lzhp/p/5197415.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!