由网友(阳光的酒调得很淡，却很醇，浅浅地斟在每一个杯形的小野花里。小)分享简介：我在多个表中插入数据。我需要知道最后插入（自动递增）表中的ID。我需要使用它作为在其他一些表一个Foriegn密钥I am inserting data in multiple tables. I need to know the last inserted (auto-incremented) ID in the...

我在多个表中插入数据。我需要知道最后插入（自动递增）表中的ID。我需要使用它作为在其他一些表一个Foriegn密钥

I am inserting data in multiple tables. I need to know the last inserted (auto-incremented) ID in the table. I need to use it as a Foriegn Key in some other table.

总之我需要的替代@@身份在T-SQL。

In short I need alternative of @@Identity in T-Sql.

推荐答案

实体框架会自动加载最后插入的ID来填充插入实体的主键列：

Entity Framework will automatically load the last inserted id to populate the primary key column of the inserted entity:

var customer = new Customer() { Name = "Steven" };

context.AddObject(customer);

context.SaveChanges();

var id = customer.Id;

注意编号属性只被填充调用的SaveChanges（）的情况下， StoreGeneratedPattern 属性被设置为标识，或计算在模型的存储部的自增ID列

Note that the Id property only gets populated after calling SaveChanges() in case the StoreGeneratedPattern attribute is set to "Identity" or "Computed" for the auto-incremented ID column in the Storage part of the model.