PLINQ with the LINQ to Excel Provider

In .Net 4.0 there are new extensions methods to take advantage of PLINQ (Parallel LINQ). These extension methods can be used quite easily in the LINQ to Excel Provider described in the post. All you need to do is add the AsParallel method to the end of the LINQ query.

ExcelProvider provider = ExcelProvider.Create(@"c:\deploy\Book1.xls");
foreach (Person per in (from p in provider.GetSheet<Person>() where p.LastName == "Johnson" select p).AsParallel())
{
per.LastName = "Smith";
}
Person p = new Person();
p.Id = 10.0;
p.FirstName = "Alex";
p.LastName = "Zander";
p.BirthDate = new DateTime(1980, 4, 4);
provider.GetSheet<Person>() InsertOnSubmit(p);
provider.SubmitChanges();
Console.WriteLine("Done");