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));
}
