Linq to Sql statement for multiple aggregate values in single expression

Question

How would I write a linq to sql statement for the following tsql?

select count(*), sum(Amount), avg(Amount), min(Amount), max(Amount) from TableName

Answer 1

It's probably easier to pull the values individually but you could do with an anonymous type.

var aggregates = new {
Count = context.TableName.Count(),
Sum = context.TableName.Sum(t => t.Amount),
Avg = context.TableName.Avg(t => t.Amount),
Min = context.TableName.Min(t => t.Amount),
Max = context.TableName.Max(t => t.Amount)
};

Answer 2

You could do:

var result = new
{
    Count = db.TableName.Count(),
    Sum = db.TableName.Sum(r => r.Amount),
    Average = db.TableName.Avg(r => r.Amount),
    Min = sb.TableName.Min(r => r.Amount),
    Max = db.TableName.Max(r => r.Amount)        
}