Cacher is the code snippet organizer for pro developers

// For complete examples and data files, please go to https://github.com/groupdocsassembly/GroupDocs_Assembly_NET
/// <summary>
/// Fetches Orders, ProductOrders and Customers from database
/// </summary>
/// <returns>Returns DataSet</returns>
public static DataSet GetCustomersAndOrdersDataDT()
{
    DatabaseEntitiesDataContext dbEntities = new DatabaseEntitiesDataContext();
    var orders = (from c in dbEntities.Orders
                  select c).AsEnumerable();
    var productOrders = (from c in dbEntities.ProductOrders
                         select c).AsEnumerable();
    var customers = (from c in dbEntities.Customers
                     select c).AsEnumerable();
    DataTable Orders = new DataTable();
    //ToADOTable function converts query results into DataTable
    Orders = orders.ToADOTable(rec => new object[] { orders });
    DataTable ProductOrders = new DataTable();
    ProductOrders = productOrders.ToADOTable(rec => new object[] { productOrders });
    DataTable Customers = new DataTable();
    Customers = customers.ToADOTable(rec => new object[] { customers });
    ProductOrders.TableName = "ProductOrder";
    Orders.TableName = "Orders";
    Customers.TableName = "Customers";
    DataSet dataSet = new DataSet();
    //Adding DataTable in DataSet
    dataSet.Tables.Add(Orders);
    dataSet.Tables.Add(ProductOrders);
    dataSet.Tables.Add(Customers);
    return dataSet;
}