I'm wondering if its possible to extend the following LINQ Query to Query multiple Dictionaries. I've tried adding a comma followed by the Dictionary name although syntax errors exist.
The datastores are stored in a List - List<SortedDictionary<DateTime, SortedDictionary<string, double>> >
var query = from d in _dataStore where (d.Key >= tempStart) && (d.Key <= tempEnd) select d.Value; var valueQuery = (from sortedDictionary in query let name = n select (from e in sortedDictionary where e.Key == name select e.Value) into query2 select query2.Single<double>() ) .OrderBy(value => value); double total = valueQuery.Any() && valueQuery.First() != -9999 ? valueQuery.Sum() : -9999;