title: How to retrieve dataset from SQL query in C#?
body: <p>I am trying to retrieve <code>Dataset</code> from a SQL query. I am using Edmx for data access. If I use one simple stored procedure for retrieving dataTable then the function works fine and when I am trying to retrieve Dataset then I am unable to convert the SQL result to a dataset.</p>
  
  <p>Here is my Sql </p>
  
  <pre><code>--Query For Retrieving LastUpdatedDate
  select top 3 
      YP.utblYPBusinessInstanceInfoKeys.BusinessID,
      YP.utblYPBusinessInstanceInfoKeys.BusinessName,
      YP.utblYPBusinessInstanceInfoKeys.LastUpdatedByDate as GeneraliseDate
  from  
      YP.utblYPBusinessInstanceInfoKeys
  order by  
      GeneraliseDate desc
  
  --Query For Retrieving Listing by CreatedDate
  select top 3 
      YP.utblYPBusinessInstanceInfoKeys.BusinessID,
      YP.utblYPBusinessInstanceInfoKeys.BusinessName,
      YP.utblYPBusinessInstanceInfoKeys.CreatedByDate as GeneraliseDate
  from  
      YP.utblYPBusinessInstanceInfoKeys
  order by  
      GeneraliseDate desc
  </code></pre>
  
  <p>How can I retrieve dataset in SQl result in C#?</p>