linq实例 - Join的使用（四）

测试的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)); }