50
1
using System;
2
using System.Collections.Generic;
3
using System.Linq;
4
5
public class Program
6
{
7
public class Student
8
{
9
public string First { get; set; }
10
public string Last { get; set; }
11
public int ID { get; set; }
12
public List<int> Scores;
13
}
14
15
16
public static void Main()
17
{
18
List<Student> students = new List<Student>
19
{
20
new Student {First="Svetlana", Last="Omelchenko", ID=111, Scores= new List<int> {97, 92, 81, 60}},
21
new Student {First="Claire", Last="O'Donnell", ID=112, Scores= new List<int> {75, 84, 91, 39}},
22
new Student {First="Sven", Last="Mortensen", ID=113, Scores= new List<int> {88, 94, 65, 91}},
23
new Student {First="Cesar", Last="Garcia", ID=114, Scores= new List<int> {97, 89, 85, 82}},
24
new Student {First="Debra", Last="Garcia", ID=115, Scores= new List<int> {35, 72, 91, 70}},
Cached Result
query1 result count: 2
query2 result count: 2
query2 result count: 2