CODEWITHSUNDEEP
c#mysqlentity-framework
vikaskumawat80
vikaskumawat80

Reputation: 131

How to get last inserted id from mysql with entity framework

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;

Upvotes: 2

Views: 825

Answers (1)

Mehmet Emin Yalçın
Mehmet Emin Yalçın

Reputation: 138

if you use database first model . you must set Identity to value of StoreGeneratedPattern property of model . if you use code first model . try this

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

Upvotes: 1

Related Questions