title: Linq results to dataset
body: <p>I use the entity framework together with Linq to get my data out of the database.
  I would like to download this data in to an excel. The ExcelLibrary works with datasets.
  is it possible to get the Linq data in an dataset, so I can easily get the data in an excel?</p>
  
  <p>I tried this, but of course this doesn't work.</p>
  
  <pre><code>    protected void btnExcelCheckListDownload_Click(object sender, EventArgs e)
      {
          DataSet dsTest = new DataSet();
          var db = new BillingEntities();
          var query = (from u in db.v_Checklist select u).AsQueryable();
          dsTest =  (DataSet)query.Select(u =&gt; u.NCR_ID).Distinct();
          ExcelLibrary.DataSetHelper.CreateWorkbook("MyExcelFile.xls", dsTest);
      }
  </code></pre>