public void TestSelect() { var emps = EmployeeCollection.Get().Where(e => e.Age > 40).Select(e => e); Assert.AreEqual(3, emps.Count(e => true)); foreach (var emp in emps) { Console.WriteLine(emp.Name); } }
public void TestSelect1() { var emps = from e in EmployeeCollection.Get() where e.Name.Length > 4 select e; Assert.AreEqual(4, emps.Count(e => true)); foreach (var emp in emps) { Console.WriteLine(emp.Name); } }
public void Sum() { Assert.AreEqual( EmployeeCollection.Get().Aggregate(0, (sum, e) => sum + ((e.Age > 40)?e.Salary:0)), EmployeeCollection.Get().Where(e => e.Age > 40).Sum(e => e.Salary)); }
public void Avg() { Assert.AreEqual(41.5, EmployeeCollection.Get().Average(e => e.Age)); }