title: Query an XML file containing nested elements using LINQPad?
body: <p>I'm using LINQPad to query and visualize XML files with C#. For example:</p>
  
  <pre><code>var xml = XElement.Load(@"C:\file.xml");
  xml.Elements().Where(e =&gt; e.Element("trHeader").Element("trTickNum").Value == "1").Dump();
  </code></pre>
  
  <p>However, I'd like run a query using SQL rather than C#.</p>
  
  <p>Is there a way to load an XML which contains nested elements and query its table(s) using LINQPad's SQL option?</p>