Export (0) Print
Expand All
0 out of 5 rated this helpful - Rate this topic

How to: Aggregate Data

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

An aggregation operation computes a single value from a collection of values. An example of an aggregation operation is calculating the average daily temperature from a month's worth of daily temperature values. This topic shows how to group orders by contact ID and get the average total due for each contact ID.

The same example is shown using LINQ to Entities and Entity SQL:

The example in this topic is based on the Adventure Works Sales Model. To run the code in this topic, you must have already added the Adventure Works Sales Model to your project and configured your project to use the Entity Framework. For more information, see How to: Use the Entity Data Model Wizard (Entity Framework) or How to: Manually Configure an Entity Framework Project and How to: Manually Define an Entity Data Model (Entity Framework).

Example

The following is the LINQ to Entities example.

The following is the Entity SQL example.

See Also

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.