C#, wie man eine Datentabelle von IQueryable einschließlich Listen mit mehreren Objekten erhält ⇐ C#

[Anonymous]

Ich habe eine IQueryable-Liste, die einige Objektlisten enthält. Ich möchte eine Datentabelle aus der Liste abrufen und als Tabelle anzeigen.

Code: Select all

IQueryable loads;

public class Load
{
public int LoadID { get; set; }
public string CustomerName { get; set; }
public List
 ShipperPickUps { get; set; }
public List ConsigneeDelivers { get; set; }
public List ReferenceNumbers { get; set; }
// ...
}

public class PickUp
{
public int? LoadID { get; set; }
public int? ShipperID { get; set; }
public string Name { get; set; }
public string Address { get; set; }
// ...
}

public class Deliver
{
public int? LoadID { get; set; }
public int? ConsigneeID { get; set; }
public string Name { get; set; }
public string Address { get; set; }
// ...
}

Jetzt sind die Daten so

Code: Select all

IQuery:
{
{
LoadID:1,
LoadNumber:"0001",
CustomerName:"Customer1",
Pickup:
{
{ LoadID: 1, ShipperID: 1, Name: "Shipper1"...},
{ LoadID: 1, ShipperID: 2, Name: "Shipper2"...},
...
}
Deliver:
{
{ LoadID: 1, ConsigneeID: 1,Name: "Consignee1"...},
{ LoadID: 1, ConsigneeID: 2,Name: "Consignee2"...},
...
}
ReferenceNumbers:
{
"Reference1",
"Reference2",
...
}
},
{
LoadID:2,
LoadNumber:"0002",
CustomerName:"Customer2",
Pickup:
{
{ LoadID: 2, ShipperID: 3, Name:"Shipper3"...},
{ LoadID: 2, ShipperID: 4, Name:"Shipper4"...},
...
}
Deliver:
{
{ LoadID: 2, ConsigneeID: 3, Name:"Consignee3"...},
{ LoadID: 2, ConsigneeID: 4, Name:"Consignee4"...},
...
}
ReferenceNumbers:
{
"Reference3",
"Reference4",
...
}
},
...
}

Ich habe eine Klasse definiert:

Code: Select all

public class ExportData
{
public int LoadID { get; set; }
public string LoadNumber { get; set; }
public string CustomerName { get; set; }
public string ShipperName{ get; set; }
public string  DeliverName{ get; set; }
public string ReferenceNumber { get; set; }
// ...
}

Ich möchte eine weitere IQueryable-Liste oder Datentabelle wie diese erhalten:

Code: Select all

IQueryable:
{
{
LoadID:1,
LoadNumber:"0001",
CustomerName:"Customer1",
ShipperName:"Shipper1",
DeliverName:"Consignee1",
ReferenceNumber:"Reference1"
...
},
{
LoadID:1,
LoadNumber:"0001",
CustomerName:"Customer2",
ShipperName:"Shipper2",
DeliverName:"Consignee2",
ReferenceNumber:"Reference2"
...
},
{
LoadID:2,
LoadNumber:"0002",
CustomerName:"Customer3",
ShipperName:"Shipper3",
DeliverName:"Consignee3",
ReferenceNumber:"Reference3"
...
},
{
LoadID:2,
LoadNumber:"0002",
CustomerName:"Customer4",
ShipperName:"Shipper4",
DeliverName:"Consignee4",
ReferenceNumber:"Reference4"
...
},
...
}

Wie geht das am besten?
Ich habe es versucht

Code: Select all

IQueryable exportData;
exportData = loads
.Select(load => new ExportData
{
LoadID = load.LoadID,
LoadNumber = load.LoadNumber,
CustomerName = load.CustomerName,
...
});

Aber ich habe keine Ahnung von den Objektlisten. Irgendwelche Vorschläge?