title: Data Reader error using Entity Framework
body: <p>I'm in the process of building a WCF Service Application which connects to an SQL Database using Entity SQL (Entity Framework). At the moment I keep getting this error with several methods:</p>
  
  <p><em>The data reader has more than one field. Multiple fields are not valid for EDM primitive or enumeration types.</em></p>
  
  <p>This is an example of one of the methods and would appreciate some advice on how to approach this:</p>
  
  <pre><code>public string[] Tables()
      {
          string Sql = @"SELECT * FROM information_schema.tables";
  
          using (var Context = new XEntities())
          {
              Context.Database.Connection.Open();
  
              IEnumerable&lt;string&gt; Query = Context.Database.SqlQuery&lt;string&gt;(Sql);              
              string[] results = Query.ToArray();
  
              Context.Database.Connection.Close();
  
              return results;
  
          }
  </code></pre>
  
  <p>The method is supposed to query the database for a list of tables and send them back in an array. This will then be inputted into a ListBox by the Windows Phone App. </p>
  
  <p>Thank You for your time.</p>