find duplicate objects within a list of lists (using linq?)

Question

I have a list of lists that I created with LINQ to contain a status code object:

List<List<StatusLookup>> statusList = new List<List<StatusLookup>>();

foreach(var action in DbmsReport.Actions){
    statusList.Add((from stat in MyFactory.CreateQueryable<StatusLookup>()
                    where stat.ActionTypes.Contains(action)
                    select stat).ToList());
}

I now need to somehow parse this statusList and find all of the StatusLookup objects that are in each list of lists, so for example:

DbmsReport.Actions = ( sprint, fight );

StatusLookup = ( { id = 0, text = "exhausted", ActionTypes = ( sprint, fight ) }
                 { id = 1, text = "tired", ActionTypes = ( jog, sprint, fight ) }
                 { id = 2, text = "rested", ActionTypes = ( sleep ) }
               );

So in this case I'd need to get a list that contains StatusLookup for "exhausted" and "tired" in no particular order, what is the best way to get this list? As can be seen in this example, there can be either 1 or more than 1 StatusLookup for each DbmsReport

Do you have to keep them as lists-of-lists? what if you flattened it out to one big list? Easy query then — n8wrl
– n8wrl, Commented Sep 5, 2012 at 14:52
No I do not have to keep it as a list of lists, please provide an example of this flattened out list — Serj Sagan
– Serj Sagan, Commented Sep 5, 2012 at 14:55
If DbmsReport.Actions = (spring,fight) do you want all StatusLookup where ActionTypes contain sprint and fight or where ActionTypes contains sprint OR fight — Bob Vale
– Bob Vale, Commented Sep 5, 2012 at 15:02

Bob Vale · Accepted Answer · 2012-09-05 15:16:40Z

1

Can you not just do?

var lookups= MyFactory.CreateQueryable<StatusLookup>()
             .Where(x=> DbmsReport.Actions.All(y=>x.ActionTypes.Contains(y))).ToList();

or if you want an or condition (ie Report= sprint,fight and you want to find all Lookups that have either sprint or fight) then

var lookups= MyFactory.CreateQueryable<StatusLookup>()
             .Where(x=> DbmsReport.Actions.Any(y=>x.ActionTypes.Contains(y))).ToList();

answered Sep 5, 2012 at 15:16

Bob Vale

18.5k1 gold badge44 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Serj Sagan Over a year ago

Perfect, the first example is what I was looking for. Thanks.

Serj Sagan Over a year ago

The problem is when I try the above I get a "Specified method is not supported." NotSupportedException This might have something to do with MyFactory being an Nhibernate factory...

Serj Sagan Over a year ago

So this did end up working, I just had to separate the MyFactory.CreateQueryable<StatusLookup>() to its own variable first, ie var allStatuses = MyFactory.CreateQueryable<StatusLookup>().ToList() then replace the MyFactory.Crea..... in our example with allStatuses

Grant H. · Accepted Answer · 2012-09-05 14:56:35Z

1

Try this to flatten it out, additionally you can add where clauses as necessary.

var r = from p in statusList
        from q in p
        select q;

answered Sep 5, 2012 at 14:56

Grant H.

3,7172 gold badges39 silver badges55 bronze badges

Collectives™ on Stack Overflow

find duplicate objects within a list of lists (using linq?)

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related