title: insert multiple records one by one using LINQ
body: <p>I'm trying to copy <code>ProductStatisticsTemp</code> table data to <code>ProductStatistics</code> table,</p>
  
  <pre><code>var str = from a in db.ProductStatisticsTemp select a;
  
  ProductStatistics ls = new ProductStatistics();
  
  foreach (var val in str.ToList())
  {                     
       ls.Product_ID = val.Product_ID;
       ls.ProductNameEn = val.ProductNameEn;
       ls.ProductNameAr = val.ProductNameAr;
  
       db.ProductStatistics.Add(ls);
       db.SaveChanges();
  }
  </code></pre>
  
  <p>first record can insert but once its try to insert 2nd one getting following error</p>
  
  <blockquote>
    <p>The property 'Product_ID' is part of the object's key information and
    cannot be modified.</p>
  </blockquote>