title: Can I use LINQPad on MS Access data directly, or by passing args to a Web API Rest method?
body: <p>I want to test out the LINQ in my Repository code:</p>
  
  <pre><code>public IEnumerable&lt;InventoryItem&gt; Get(string ID, string packSize, int CountToFetch)
  {
      return inventoryItems.Where(i =&gt; 0 &lt; String.Compare(i.Id, ID)).Where(i =&gt; 0 &lt; String.Compare(i.PackSize.ToString(), packSize)).Take(CountToFetch);
  }
  </code></pre>
  
  <p>...and am trying to use LINQPad to do that.</p>
  
  <p>The data comes from an MS Access database; seeing that LINQPad doesn't seem to support Access "out of the box" that way, I wonder if either there's a driver for that (couldn't fine one - don't have the DevExpress product needed to use their driver), or if I could query by attaching to my Web API Rest method inside LINQPad?</p>
  
  <p>I tried the SQL Server driver, hoping that would work for Access, too; I tried the WCF driver, hoping maybe that would work with Web API, but neither worked; with the latter attempt, I got, "XmlException: Data at the root level is invalid. Line 1, position 1."</p>