Using LINQ is this the best way to clear a table? RSS

• • Reply
  

  eric2820

  Contributor

  2777 Points

  1161 Posts

  Using LINQ is this the best way to clear a table?

  Feb 24, 2012 08:35 PM|LINK

  
  foreach ( LogErrors log in GetAll() )
          db.LogErrors.Remove( log );
  
   db.SaveChanges();

  Eric
  
  http://www.my-msi.net/Admin
  blog
  
  If a post helps you, please mark it as Ansered, thank-you.
• • Reply
  

  CodeHobo

  All-Star

  18669 Points

  2648 Posts

  Re: Using LINQ is this the best way to clear a table?

  Feb 24, 2012 08:51 PM|LINK

  If you want to use straight linq, I believe you have to do them one at a time like you have above.

  Have you tried using inline sql? this is faster 

   db.Database.ExecuteSqlCommand("Truncate table LogErrors");

  Hattan Shobokshi
  Blog | Twitter : @Hattan
  
  • Edited by CodeHobo on Feb 24, 2012 08:51 PM
  • Marked as answer by eric2820 on Feb 24, 2012 09:34 PM