public void AvgDouble() { IEnumerable <double> source = TestData.GetDoubles(); double result = source.QueryScalar <double>("SELECT avg(value()) FROM this"); Assert.IsTrue(result == source.Average()); }
public void StdevPDouble() { IEnumerable <double> source = TestData.GetDoubles(); double result = source.QueryScalar <double>("SELECT StdevP(value()) FROM this"); Assert.AreEqual(result, 1.7555269864060763, double.Epsilon); }
public void StdevDouble() { IEnumerable <double> source = TestData.GetDoubles(); double result = source.QueryScalar <double>("SELECT Stdev(value()) FROM this"); Assert.AreEqual(result, 2.0271079563424013, double.Epsilon); }
public void VarPDouble() { IEnumerable <double> source = TestData.GetDoubles(); double result = source.QueryScalar <double>("SELECT varp(value()) FROM this"); Assert.AreEqual(result, 3.081875, double.Epsilon); }
public void WhereInValueDouble() { IEnumerable <double> source = TestData.GetDoubles(); var result = source.Query <double>("SELECT * FROM this WHERE value() IN(2.1, 4.6)"); var answer = from d in source where (new List <double> { 2.1, 4.6 }).Contains(d) select d; Assert.IsTrue(result.Any()); Assert.IsTrue(answer.Any()); Assert.IsTrue(answer.SequenceEqual(result)); }