Tuesday, March 1, 2011

Linq to Sql: Can I return the Identity_Scope after an insert?

After I do an insert using linq to sql, can I get the Identity_scope value back if my table has an identity column?

From stackoverflow
  • Linq to SQL does the job for you, the identity value it's available just after the SubmitChanges method is called.

    var entity = new Entity();
    // ...
    ctx.Entities.InsertOnSubmit(entity);
    ctx.SubmitChanges();
    // Here you can use the generated value of yout identity column
    
    entity.Id;
    
    Jeremy : It was way to obvious for me to see :) Thanks.

0 comments:

Post a Comment