LINQ select in C dictionary

Question

I have next dictionary in C   Dictionary lt string  object gt  subDictioanry   new Dictionary lt string  object gt      List lt Dictionary lt string  string gt  gt  subList   new List lt Dictionary lt string  string gt  gt      subList Add new Dictionary lt string  string gt           valueLink    link1          valueTitle   title1       subList Add new Dictionary lt string  string gt           valueLink    link2          valueTitle   title2       subList Add new Dictionary lt string  string gt           valueLink    link3          valueTitle   title3        subDictioanry Add  title    title    subDictioanry Add  name    name    subDictioanry Add  fieldname1   subList    Dictionary lt string  object gt  exitDictionary   new Dictionary lt string  object gt     exitDictionary Add  first   subDictioanry   exitDictionary Add  second   subDictioanry     Is it possible to get all  valueTitle  with help of LINQ select   UPDATE  Sorry  i should write it first - i need to get result from exitDictionary  not from subList

User · Answer

var res   exitDictionary              Select p   gt  p Value  Cast lt Dictionary lt string  object gt  gt                 SelectMany d   gt  d               Where p   gt  p Key     quot fieldname1 quot                Select p   gt  p Value  Cast lt List lt Dictionary lt string string gt  gt  gt                 SelectMany l   gt  l               SelectMany d  gt  d               Where p   gt  p Key     quot valueTitle quot                Select p   gt  p Value               ToList     This also works  and easy to understand

User · Answer

This will return all the values matching your key valueTitle  subList SelectMany m   gt  m  Where kvp   gt  kvp Key     valueTitle   Select k   gt  k Value  ToList

User · Answer

One way would be to first flatten the list with a SelectMany   subList SelectMany m   gt  m  Where k   gt  k Key Equals  valueTitle

User · Answer

If you are searching by the fieldname1 value  try this   var r   exitDictionary     Select i   gt  i Value  Cast lt Dictionary lt string  object gt  gt        Where d   gt  d ContainsKey  fieldname1        Select d   gt  d  fieldname1    Cast lt List lt Dictionary lt string  string gt  gt  gt        SelectMany d1   gt          d1          Where d   gt  d ContainsKey  valueTitle             Select d   gt  d  valueTitle             Where v   gt  v    null   ToList      If you are looking by the type of the value in the subDictionary  Dictionary lt string  object gt  explicitly   you may do this   var r   exitDictionary     Select i   gt  i Value  Cast lt Dictionary lt string  object gt  gt        SelectMany d  gt d Values      OfType lt List lt Dictionary lt string  string gt  gt  gt        SelectMany d1   gt          d1          Where d   gt  d ContainsKey  valueTitle             Select d   gt  d  valueTitle             Where v   gt  v    null   ToList      Both alternatives will return   title1 title2 title3 title1 title2 title3

[c#] LINQ select in C# dictionary

Examples related to c#

Examples related to linq

Examples related to dictionary