I start learning LINQ these days. I got an error when I try to return an anonymous type in join query. And I don't understand why I get this error. Here is my coding.
List<Student> students = new List<Student>()
{
new Student{First="Svetlana",Last="Omelchenko",ID=111,Scores= new List<int>(){97,92,81,60}},
new Student{First="Claire",Last="O'Donnell",ID =112,Scores=new List<int>(){75,84,91,39}},
new Student{First ="Sven",Last="Mortensen",ID =113,Scores=new List<int>(){88,94,65,91}},
new Student{First ="Cesar",Last="Garcia",ID=114,Scores=new List<int>(){97,89,85,82}}
};
List<ContactInfo> contactList = new List<ContactInfo>()
{
new ContactInfo{ID=111,Email="Contoso",Phone= "206-555-0108"},
new ContactInfo{ID=112,Email="[email protected]",Phone="206-555-0298"},
new ContactInfo{ID=113,Email="[email protected]",Phone="206-555-1130"},
new ContactInfo{ID=114,Email="[email protected]",Phone="206-555-0521"}
};
var cInfo =
from student in students
where student.Scores.Average() > 85
join ci in contactList on student.ID equals ci.ID
select new { ci.Email, student.First };
foreach (var c in cInfo)
Console.WriteLine("{0)'s email is {1}", c.First, c.Email);
In the anonymous type, I get the email from contactList and student's first name. I can not do like this ???
Thanks in advance.
Kevin
