一,Join使用(等同于SQL语句的内连接,条件必须相等)
List<person> pp = new List<person>() {
new person() { age=11,isread=true,name="1isi"},
new person() { age=21,isread=true,name="2isi"},
new person() { age=31,isread=true,name="3isi"},
new person() { age=41,isread=true,name="4isi"},
new person() { age=51,isread=true,name="5isi"},
};
List<int> pp2 = new List<int>() { 11, 31 };
var ppres2 = pp.Join(pp2, p => p.age, n => n, (p, n) => new { p, n }).Select(o => o.p);
得到的结果就是:pp里面的age=11和age=31的结果;
List<person> pp3 = new List<person>() {
new person() { age=11,name="1isi"},
new person() { age=21,name="2isiX"},
};
var ppres3 = pp.Join(pp3, p => new { p.age, p.name }, n => new { n.age, n.name }, (p, n) => new { p, n }).Select(o => o.p);
得到的结果就是:pp里面的age=11的结果;age=21不满足因为name="2isiX"与pp里面的name不一致,必须同时满足age和name都一致才可以。
DataTable dt = new DataTable();
dt.Columns.Add("prizename");
dt.Columns.Add("point");
dt.Columns.Add("number");
dt.Columns.Add("totalpoint");
dt.Columns.Add("prizeid");
for (int i = 0; i < 10; i++)
{
DataRow dr2 = dt.NewRow();
dr2["prizename"] = "娃娃"+i;
dr2["point"] = 10;
dr2["number"] = 1 + i;
dr2["totalpoint"] = 10;
dr2["prizeid"] = "001" + i;
dt.Rows.Add(dr2);
}
DataTable dt2 = new DataTable();
dt2.Columns.Add("prizename");
DataRow dr = dt2.NewRow();
dr["prizename"] = "娃娃2";
dt2.Rows.Add(dr);
dr = dt2.NewRow();
dr["prizename"] = "娃娃4";
dt2.Rows.Add(dr);
dr = dt2.NewRow();
dr["prizename"] = "娃娃7";
dt2.Rows.Add(dr);
var dtres = dt.AsEnumerable().Join(dt2.AsEnumerable(),
p => p.Field<string>("prizename"),
n => n.Field<string>("prizename"),
(p, n) => new { p, n }).Select(o=>o.p).ToList();
得到的结果就是:dt里面的prizename= "娃娃2";prizename= "娃娃4";prizename= "娃娃7";的整行数据。
当然也可以筛选出dt里面同时满足多列数据的结果集:可以参照ppres3 的写法;
二,GroupJoin使用(等同于SQL语句的左连接left join)
List<person> pp = new List<person>() {
new person() { age=11,isread=true,name="1isi"},
new person() { age=21,isread=true,name="2isi"},
new person() { age=31,isread=true,name="3isi"},
new person() { age=41,isread=true,name="4isi"},
new person() { age=51,isread=true,name="5isi"},
};
List<stdu> stu = new List<stdu>()
{
new stdu() { name = "1isi", teacher = "001" },
new stdu() { name = "3isi", teacher = "002" }
};
var stures = pp.GroupJoin(stu, p => p.name, n => n.name,
(p, t) => new { age=p.age, name=p.name, teachers=t.Select(k=>k.teacher).FirstOrDefault() });
//Group Join的标准表达式写法:
var stures = from a in pp
join b in stu
on a.name equals b.name into t
select new
{
ID = a.name,
Content = a.age,
teacher = string.Join(",", t.Select(x => x.teacher.ToString()).ToArray())
};
得到的结果为:
{ age=11,isread=true,name="1isi",teacher = "001"},
{ age=21,isread=true,name="2isi",teacher = null},
{ age=31,isread=true,name="3isi",teacher = "002"},
{ age=41,isread=true,name="4isi",teacher = null},
{ age=51,isread=true,name="5isi",teacher = null},
是把2个集合的数据拼接一起组成一个新的数据集。