How to get XML into a Dictionary with an Expression?

Posted by DaveDev on Stack Overflow See other posts from Stack Overflow or by DaveDev
Published on 2010-06-11T09:27:55Z Indexed on 2010/06/11 9:32 UTC
Read the original article Hit count: 235

I have the following XML:

  <PerformancePanel page="PerformancePanel.ascx" title="">
    <FundGroup heading="Net Life Managed Funds">
      <fund id="17" countryid="N0" index="24103723" />
      <fund id="81" countryid="N0" index="24103723" /> 
      <fund id="127" countryid="N0" index="24103722" />
      <fund id="345" countryid="N0" index="24103723" />
      <fund id="346" countryid="N0" index="24103723" />
    </FundGroup>
    <FundGroup heading="Net Life Specialist Funds">
      <fund id="110" countryid="N0" index="24103717" />
      <fund id="150" countryid="N0" index="24103719" />
      <fund id="119" countryid="N0" index="24103720" />
      <fund id="115" countryid="N0" index="24103727" />
      <fund id="141" countryid="N0" index="24103711" />
      <fund id="137" countryid="N0" />
      <fund id="146" countryid="N0" />
      <fund id="133" countryid="N0" />
      <fund id="90" countryid="N0"  />
      <fund id="104" countryid="N0" />
      <fund id="96" countryid="N0" />
    </FundGroup>
  </PerformancePanel>

I can get the data into an anonymous object as follows:

    var offlineFactsheet = new
                               {
   PerformancePanels =
    (from panel in doc.Elements("PerformancePanel")
     select new PerformancePanel
     {
         PerformanceFunds = (from fg in panel.Elements("FundGroup")
                             select new
                             {
                                 Heading = (fg.Attribute("heading") == null)
                                            ? ""
                                            : (string)fg.Attribute("heading"),
                                 Funds =
                                    (from fund in fg.Elements("fund")
                                     select new Fund
                                     {
                                         FundId = (int)fund.Attribute("id"),
                                         CountryId = (string)fund.Attribute("countryid"),
                                         FundIndex = (fund.Attribute("index") == null)
                                                 ? null
                                                 : new Index
                                                 {
                                                     Id = (int)fund.Attribute("index")
                                                 },
                                         FundNameAppend = (fund.Attribute("append") == null)
                                                 ? ""
                                                 : (string)fund.Attribute("append")
                                     }).ToList()
                             }).ToDictionary(xx => xx.Heading, xx => xx.Funds)};

I'm trying to change my code such that I can assign the dictionary directly to a property of the class I'm working in, as described in this question. I'd like to have a Dictionary() where each header text is the key to the list of funds under it. I'm having difficulty applying the example in the linked question because that only returns a string, and this needs to return the dictionary.

This is the point that I got to before it occurred to me that I'm lost!!!:

this.PerformancePanels = doc.Elements("PerformancePanel").Select(e =>
 {
     var control = (PerformancePanel)LoadControl(this.OfflineFactsheetPath
                                                + (string)e.Attribute("page"));

     control.PerformanceFunds = e.Elements("FundGroup").Select(f =>
     {
         List<Fund> funds = (from fund in e.Elements("fund")
                             select new Fund
                                        {
                                            FundId = (int)fund.Attribute("id"),
                                            CountryId = (string)fund.Attribute("countryid"),
                                            FundIndex = (fund.Attribute("index") == null)
                                                            ? null
                                                            : new Index
                                                                  {
                                                                      Id = (int)fund.Attribute("index")
                                                                  },
                                            FundNameAppend = (fund.Attribute("append") == null)
                                                                 ? ""
                                                                 : (string)fund.Attribute("append")
                                        }).ToList();
         string heading = (e.Attribute("heading") == null)
                              ? ""
                              : (string)e.Attribute("heading");
     }).ToDictionary(xx => heading, xx => Funds);
     return control;
 }).ToList();

Could someone point me in the right direction please? I'm not even sure if 'Expression' is the right terminology. Could someone fill me in on that too? Thanks.

© Stack Overflow or respective owner

Related posts about c#

Related posts about linq-to-xml