title: Get columns values in data table using linq from Entity Framework
body: <p>I am new to LINQ queries, please help me out to find the solution.</p>
  
  <p>I have a source in Entity Framework data model, there is a table <code>currency</code> bound to the source with columns <code>currencyID</code> and <code>CurrencyName</code>. </p>
  
  <p>I need to get the values from the database to the <code>DataTable</code> using a LINQ query.</p>
  
  <p>I tried something like mentioned below but it's not working:</p>
  
  <pre><code> var dataset = Source.T_Currency
      .Where(x=&gt; x.CurrencyID == x.CurrencyID &amp;&amp;  x.CurrencySymbol == x.CurrencySymbol)
      .Select(x =&gt; new x.Currency
      {
          CurrencyID = x.CurrencyID,
          CurrencySymbol = x.CurrencySymbol
      }).ToList();
  </code></pre>