title: Returning a Dictionary<string, string> from a linq query
body: <p>I have a table with 2 columns defined as varchar(50): Column1 and Column2. I want to return a dictionary of <code>&lt;string, string&gt;</code> where each row is in the dictionary and where Column1 is the key and Column2 is the value. This is what I have:</p>
  
  <pre><code>public Dictionary&lt;string, string&gt; LoadAllTheDataFromDB()
  {
     using (MyDC TheDC = new MyDC())
     {
         return (from c in TheTable
                 select new Dictionary&lt;string, string&gt;()
                 {
                       //stuck here
  
                 }).FirstOrDefault();
  
     }
  }
  </code></pre>
  
  <p>How do I make it that the dictionary is filled? </p>