troubleshooting Question

C# Extend LINQ to Query multiple Dictionaries

Avatar of AndyC1000
AndyC1000 asked on
C#
4 Comments1 Solution801 ViewsLast Modified:
Hello,

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>> >

Thanks

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;
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros