Sum subitems

[Zbigniew Kozłowski]

Hi,
i got a question how can i achive to sum price of all invoice elements? i mean i tried something like that:

var query = from i in scope.Extent<Invoice>()
                        select new
                        {
                            Id = i.Id,
                            Code = i.Code,
                            ContactDescription = i.Contact.Description,
                            Price = (from ii in i.Invoiceitems select new { Price = ii.Price * ii.Quantity }).Sum(ii => ii.Price),
                            DocumentDate = i.DocumentDate
                        };

but it throws error with sum on server side

tried also something like this:

var query = from i in scope.Extent<Invoice>()
                        select new
                        {
                            Id = i.Id,
                            Code = i.Code,
                            ContactDescription = i.Contact.Description,
                            Prices = i.Invoiceitems.Sum(p=> (p.Quantity*p.Price)),
                            DocumentDate = i.DocumentDate
                        };

is it possible to make such sum?

[Jordan]

Hi Zbigniew Kozłowski,

Thank you for writing.
Unfortunately OpenAccess does not have support for sub-selects in LINQ queries yet.
And this is why you are getting errors when you try to execute such a query.
We are working to improve our sub-select support and our LINQ support in general but unfortunately I cannot give you a time frame at the moment when such queries will be supported by OpenAccess.

Sincerely yours,
Jordan
the Telerik team