>Does this not work because I need to Groupby GoodsType.Description and TransactionType.Descriptiion and both have the same name.
>Is there a away around this?
>Or ... is this why you should always prefix your field names? :(
>
>
> var pBI = context.TransactionDetails.
> GroupBy(t => new { t.Parcel.GoodsType.Description, t.TransactionHeader.TransactionType.Description }, (key, g) =>
> new
> {
> Transaction = key.Description,
> Goods = key.Description,
> Weight = g.Select(t => t.Weight),
> Amount = g.Select(x => x.Amount)
> });
>
var pBI = context.TransactionDetails.
GroupBy(t => new {
parcelDescription = t.Parcel.GoodsType.Description,
transactionDescription = t.TransactionHeader.TransactionType.Description
}, (key, g) =>
new
{
Transaction = key.parcelDescription,
Goods = key.transactionDescription,
Weight = g.Select(t => t.Weight),
Amount = g.Select(x => x.Amount)
});