public void TestLinqAverage()
{
var connectionString = GetConnectionString("TestLinqAverage");
var context = new MyEntityContext(connectionString);
var e1 = context.TestEntities.Create();
e1.SomeInt = 10;
e1.SomeDecimal = 10;
e1.SomeDouble = 10;
var e2 = context.TestEntities.Create();
e2.SomeInt = 12;
e2.SomeDecimal = 12;
e2.SomeDouble = 12;
var e3 = context.TestEntities.Create();
e3.SomeInt = 15;
e3.SomeDecimal = 15;
e3.SomeDouble = 15;
var e4 = context.TestEntities.Create();
e4.SomeInt = 10;
e4.SomeDecimal = 10;
e4.SomeDouble = 10;
var e5 = context.TestEntities.Create();
e5.SomeInt = 11;
e5.SomeDecimal = 11;
e5.SomeDouble = 11;
context.SaveChanges();
Assert.AreEqual(5, context.TestEntities.Count());
var avInt = context.TestEntities.Average(e => e.SomeInt);
Assert.IsNotNull(avInt);
Assert.AreEqual(11.6, avInt);
var avDec = context.TestEntities.Average(e => e.SomeDecimal);
Assert.IsNotNull(avDec);
Assert.AreEqual(11.6m, avDec);
var avDbl = context.TestEntities.Average(e => e.SomeDouble);
Assert.IsNotNull(avDbl);
Assert.AreEqual(11.6, avDbl);
}