How to get the identity column after insert data

[Byland]

Hi, All

I saw the old ORM API, I can get the identity data from database:
 
scope.Transaction.Begin();
Customer c = new Customer();
c.Name = "Smith";
c.CustomerNo = 34567;
scope.Add( c );
// during the Add() call, an object identifier
// is assigned to the new Customer object
IObjectId id = scope.GetObjectId( c );
scope.Transaction.Commit();

But how can i do like this using the new ORM API

context.get.....???????

Any one can give me some suggestion?

Thanks a lot!!!

Byland

[IT-Als]

Hi Byland,

Just right after the context.Add method you can do a context.GetScope().Transaction.Flush()

It will execute all server side calculated Ids and populate those Ids to your objects, so you can read it from there by doing a customer.Id for example.

Regards

Henrik

[Byland]

Hi, Henrik

A lot of thx!!!!!!

[IT-Als]

Hi Byland,

You're welcome. If it helped you, it might help others, too. So please mark the answer as the solution to your question. It will help others find a solution more quickly. Thanks

Regards
Henrik