How to get id values for multiple rows inserted in a table?

abhi
abhi
in General

I am using LINQ 2 SQL. When a record is inserted, the identity key on the table is created. I am inserting multiple records via LINQ 2 SQL. How can I get their Id values back after the insert is done?

· Share on Facebook

Comments

  • JoeAlbahari
    JoeAlbahari

    LINQ-to-SQL automatically populates the identity values, so it's simply a matter of checking the entities that you inserted after calling SubmitChanges().

    · Share on Facebook
  • abhi
    abhi

    Thanks for the suggestion. I will have to think of some way since in an OLTP system, I am getting millions of records inserted every hour.

    · Share on Facebook

Categories