如何在LINQ中获取最后插入的ID

Question

我有两个表，user和student。 user是父表，student是子表。

因此从以下代码中

public void adduserStudenttype(StudentAddUserModel s)
{
    using (DASEntities db = new DASEntities())
    {
        user u = new user();
        u.usersEmail = s.Email;
        u.usersPassword = s.Password;
        u.usersFname = s.Fname;
        u.usersUtype = s.UserType;
        db.user.Add(u);
        db.SaveChanges();
        
        student stud = new student();
        stud.studentID = \\ how to get the id in the user last insert
    }     
}

如何从user表中获取最后插入的id？id是user表中的主键。

- reid

Answer 1

您可以按照以下方式获取它：

// I suppose that the corresponding's property name is ID.
// If it is not, you should change it correspondingly.
stud.studentID = u.ID;

- Christos