c# - 如何使用 Entity Framework 从mysql获取最后插入的id

Question

var forSentTable = new mailsent { Subject = Subject.Text, Mailbody = editor1.InnerText, SentTime = DateTime.Now, SentBy = mailFromEmail };

// var forSentTableBody = new MailSent { };
context.mailsents.Add(forSentTable);

//context.MailSents.Add(forSentTableBody);
context.SaveChanges();

//tried this one but not working with mysql(but it works with sql server)
var mailID = forSentTable.MailID;

Answer 1

如果您使用数据库优先模型。您必须将 Identity 设置为 model 的 StoreGeneratedPattern 属性的值。 如果您使用代码优先模型。试试这个

[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
 public Guid ID { get; set; }