测试的class。
public class user
{
private string firstName;
private string lastName;
private int id;
public string FirstName
{
get { return this.firstName; }
private set { }
}
public string LastName
{
get { return this.lastName; }
private set { }
}
public int ID
{
get { return this.id; }
private set { }
}
public user(string firstName, string lastName, int id)
{
this.firstName = firstName;
this.lastName = lastName;
this.id = id;
}
}
现在开始测试。
//准备数据。
user[] Users = new user[3];
Users[0] = new user(lastName: "Liu", firstName: "Andy", id:1);
Users[1] = new user(lastName: "Gao", firstName: "Shan", id: 2);
Users[2] = new user(lastName: "Liu", firstName: "Patrick", id: 3);
int[] ids = new int[2]{1,3};
int[] ids2 = new int[1] { 1 };
//使用LinQ来去。意思是在Users, 把Users符合条件的记录,user的id在ids和ids2出现的记录,以LastName为group,放在usergroup里。然后把usergroup返回给newUsers
var newUsers = from u in Users
//看看这里就是使用join链接不同的地方。等于的时候是用equals
join i in ids on u.ID equals i
join i2 in ids2 on u.ID equals i2 //join可以多个。但是没有测试最多是多少个。
group u by u.LastName
into usergroup
select usergroup;
//循环显示。
foreach (var a in newUsers) //a是group来的。可能包含不止一个记录。
{
foreach(user b in a)//再次循环,把a包含的循环拿出来。这里的b是user对象了。
MessageBox.Show(String.Format("{0},{1}",b.LastName, b.FirstName));
}