Update two columns in a DataTable using LINQ

Question

I want to update two columns of DataTable in a single line using LINQ query. Currently I am using following two lines to do the same:

oldSP.Select(string.Format("[itemGuid] = '{0}'", itemGuid)).ToList<DataRow>().ForEach(r => r["startdate"] = stDate);
oldSP.Select(string.Format("[itemGuid] = '{0}'", itemGuid)).ToList<DataRow>().ForEach(r => r["enddate"] = enDate);

How can I do this in one line, using one Select?

Answer 1

Use curly bracers to do two on more operations:

oldSP.Select(string.Format("[itemGuid] = '{0}'", itemGuid))
       .ToList<DataRow>()
       .ForEach(r => { r["enddate"] = enDate); r["startdate"] = stDate; });

But for code readability I would use old-fashioned foreach loop.