如何在DataSet 4中返回DataSet

Question

我有一个返回obj Data的方法，但是我需要返回DataSet

public static Data GetData(int id)
{
    var result = new Data();
    using (var context = new MyContext(false, false)) 
    {
        var query = context.Data.Include("MyTable1").Include("MyTable2").Include("MyTable3").Where(o => o.Id == id);
        result = query.OrderBy(onc => onc.Data).FirstOrDefault();
    }
    return result;
}

我是实体框架的新手，任何如何返回DataSet而不是对象的例子。

Answer 1

将Data对象添加到Dataset中并返回它。

举个例子，

 private DataSet ConvertToDataSet(Data yourObject) 
 {
     DataTable dt = new DataTable();
     //build the columns by your fields
     dt.Columns.Add("Id", typeof(int));
     dt.Columns.Add("Name", typeof(string));

     DataRow row = dt.NewRow();
     row["Id"] = yourObject.Id;
     row["Name"] = yourObject.Name
     dt.Rows.Add(row);

     DataSet ds = new DataSet();
     ds.Tables.Add(dt);
     return ds;
  }



  public static DataSet GetData(int id)
  {
    var result = new Data();
    using (var context = new MyContext(false, false)) 
    {
        var query = context.Data.Include("MyTable1").Include("MyTable2").Include("MyTable3").Where(o => o.Id == id);
        result = query.OrderBy(onc => onc.Data).FirstOrDefault();
    }
    return ConvertToDataSet(result);
  }