How can I load the following XML using LINQ-to-XML into a dictionary?

Question

How can I load the following formatted XML document:

<Settings>
    <MimeTypes>
        <MimeType Type="application/mac-binhex40" Extensions=".hqx"/>
        <MimeType Type="application/msword" Extensions=".doc;.docx"/>
        <MimeType Type="application/pdf" Extensions=".pdf"/>
        <MimeType Type="application/vnd.ms-excel" Extensions=".xla;.xlc;.xlm;.xls;.xlt;.xlw;.xlsx"/>
    </MimeTypes> 
</Settings>

Into a dictionary where the key is an individual extension, and the value is the mimetype.

So, for this line:

<MimeType Type="application/vnd.ms-excel" Extensions=".xla;.xlc;.xlm;.xls;.xlt;.xlw;.xlsx"/>

I would have the following key-value entries:

Key: ".xla" Value: "application/vnd.ms-excel"
Key: ".xlc" Value: "application/vnd.ms-excel"
Key: ".xlm" Value: "application/vnd.ms-excel"
Key: ".xls" Value: "application/vnd.ms-excel"
Key: ".xlt" Value: "application/vnd.ms-excel"

I'm relatively new to the LINQ-To-XML business.

I know that I should load in the document into an XElement like:

 XElement settingsDoc = XElement.Load("Settings.xml");

However, how to do I select all "MimeType" entries?

Answer 1

Something like:

 var dictionary = (from element in settingsDoc.Descendants("MimeType")
                   from extension in element.Attribute("Extensions")
                                         .Value.Split(';')
                   select new { Type = element.Attribute("Type").Value,
                                Extension = extension })
                   .ToDictionary(x => x.Extension,
                                 x => x.Type);