<p>Everything I can find in linq for aggregation has a "group by" clause.  How would I write this query in LINQ?  I have a list of date-value pairs, and I want to take the average of the values:</p>

<pre><code>SELECT AVG(MySuff.Value) AS AvgValue FROM MyStuff
</code></pre>

morning Alan:
```
```
int count = (from a in myContext.MyStuff
            select a).Count();
```
```
Assuming myContext is the DataContext.
Note that is gives you immediate execution, which you may not want.
You could instead store the results of the query in a var:
```
```
var allResults = from a in myContext.MyStuff
                 select a;

//sometime later when needed
int count = allResults.Count(); // executes the SQL query now!
```
```