title: updating multiple records in database with linq to sql without loop, is it possible?
body: <p>ok, let say i want to update multiple rows in database at once, without looping, if we do it with loop, it might look like this : </p>
  
  <pre><code>var products = (from prod in context.Products
                 where prod.ProductCategoryID == myProductID
                 select prod).ToList();
  
  
  // modify each object
  foreach (var product in products)
  {
      product.PhoneNumber = ???;
      product.Name = ???;
      product.Address = ???;
  }
  
  
  context.SubmitChanges();
  </code></pre>
  
  <p>is there better way to do this? without doing any loop? consider me as a beginner on linq, so if there is some better way, it would be great if you provide me some example, thanks in advance.</p>