How to get the Identity value from C# object initializer [duplicate]

Question

I am using Object initializer to insert data into table using Entity Framework. Data is saving into database perfectly , but i want to retrieve the Identity from that table .

Here is my code :-

db.CMSQUEs.Add(new CMSQUE
  {
    queedfcodequestiontype = questionEdfValue.ToString(),
    quenotes = model.QuestionDescription,
    queisexternaltext = false,
    quenumofoptions = model.NoofOptions,
    queusmrefidcreatedby = Convert.ToInt32(System.Web.HttpContext.Current.Session["usmrefid"]),
    quescore = model.QuestionScore / model.NoofQuestions,
    quetime = model.QuestionDuration  
  });

 db.SaveChanges();

But I don't know how to retrieve the Identity from that table ??

DavidG · Accepted Answer · 2014-08-05 09:40:08Z

2

You need to first keep the entity object then reload it after you have inserted it:

var cmsque = new CMSQUE
{
    queedfcodequestiontype = questionEdfValue.ToString(),
    quenotes = model.QuestionDescription,
    queisexternaltext = false,
    quenumofoptions = model.NoofOptions,
    queusmrefidcreatedby = Convert.ToInt32(System.Web.HttpContext.Current.Session["usmrefid"]),
    quescore = model.QuestionScore / model.NoofQuestions,
    quetime = model.QuestionDuration  
};

db.CMSQUEs.Add(cmsque);
db.SaveChanges();
db.Entry(cmsque).GetDatabaseValues();

var identityValue = cmsque.ID;

answered Aug 5, 2014 at 9:40

DavidG

120k13 gold badges232 silver badges239 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Naveen Over a year ago

I don't have the minimum point to upvote you. But thanks

Ronald Wildenberg · Accepted Answer · 2014-08-05 09:40:17Z

2

You should do the following:

var cmsQueue = new CMSQUEUE { ... };
db.CMSQUEs.Add(cmsQueue);
db.SaveChanges();

// Get the id from the object.
var id = cmsQueue.Id;

Entity Framework makes sure the identity property is set on the object you insert. So it's simply a matter of rearranging some code.

answered Aug 5, 2014 at 9:40

Ronald Wildenberg

32.3k17 gold badges95 silver badges133 bronze badges

Collectives™ on Stack Overflow

How to get the Identity value from C# object initializer [duplicate]

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related