public void TestLinqSum()
{
var connectionString = GetConnectionString("TestLinqSum");
var context = new MyEntityContext(connectionString);
var e1 = context.TestEntities.Create();
e1.SomeInt = 10;
e1.SomeDecimal = 10.1m;
e1.SomeDouble = 10.2;
var e2 = context.TestEntities.Create();
e2.SomeInt = 12;
e2.SomeDecimal = 12.1m;
e2.SomeDouble = 12.2;
var e3 = context.TestEntities.Create();
e3.SomeInt = 15;
e3.SomeDecimal = 15.1m;
e3.SomeDouble = 15.2;
var e4 = context.TestEntities.Create();
e4.SomeInt = 10;
e4.SomeDecimal = 10.1m;
e4.SomeDouble = 10.2;
var e5 = context.TestEntities.Create();
e5.SomeInt = 11;
e5.SomeDecimal = 11.1m;
e5.SomeDouble = 11.2;
context.SaveChanges();
Assert.AreEqual(5, context.TestEntities.Count());
var sumInt = context.TestEntities.Sum(e => e.SomeInt);
Assert.IsNotNull(sumInt);
Assert.AreEqual(58, sumInt);
var sumDec = context.TestEntities.Sum(e => e.SomeDecimal);
Assert.IsNotNull(sumDec);
Assert.AreEqual(58.5m, sumDec);
var sumDbl = context.TestEntities.Sum(e => e.SomeDouble);
Assert.IsNotNull(sumDbl);
Assert.AreEqual(59.0, sumDbl);
}