问题描述
当我使用 Linq-to-SQL 将一个对象输入到数据库中时,我可以在不进行另一个数据库调用的情况下获取我刚刚插入的 id 吗?我假设这很容易,我只是不知道如何.
When I enter an object into the DB with Linq-to-SQL can I get the id that I just inserted without making another db call? I am assuming this is pretty easy, I just don't know how.
推荐答案
将对象提交到数据库后,对象会在其 ID 字段中收到一个值.
After you commit your object into the db the object receives a value in its ID field.
所以:
myObject.Field1 = "value"; // Db is the datacontext db.MyObjects.InsertOnSubmit(myObject); db.SubmitChanges(); // You can retrieve the id from the object int id = myObject.ID;