public void TestLinqAverage2()
{
var connectionString = GetConnectionString("TestLinqAverage2");
var context = new MyEntityContext(connectionString);
var ages = new List<int>();
for (int i = 0; i < 1000; i++)
{
var entity = context.TestEntities.Create();
entity.SomeString = "Person" + i;
int age = 20 + (i / 20);
entity.SomeInt = age;
ages.Add(age);
}
context.SaveChanges();
var total1 = context.TestEntities.Sum(e => e.SomeInt);
var total2 = ages.Sum();
var q1 = context.TestEntities.Count();
var q2 = ages.Count;
Assert.AreEqual(total2 / q2, total1 / q1);
Assert.AreEqual(1000, context.TestEntities.Count());
Assert.AreEqual(ages.Average(), context.TestEntities.Average(e => e.SomeInt));
}