分布类 关键字是:partial
我们排序orderby ascending升序 descending降序
var result=from f in food
orderby f ascending
select f;
Console.WriteLine("-----------升序----------");
foreach (var item in result)
{
Console.WriteLine(item);
}
模糊查询
string str = Console.ReadLine();
var result = from f in food
where f.Contains(str)
select f;
foreach (var item in result)
{
Console.WriteLine(item);
}
分组 group
// from 语句
var srult = from fu in ulist
group fu by fu.username.Substring(0,2);
//遍历分组的数据
foreach (var item in srult)
{
Console.WriteLine("分组键是:{0}",item.Key);
foreach (var it in item)
Console.WriteLine("名字是:{0},年龄是:{1}",it.username,it.age);
}
联接 join
我们排序orderby ascending升序 descending降序
var result=from f in food
orderby f ascending
select f;
Console.WriteLine("-----------升序----------");
foreach (var item in result)
{
Console.WriteLine(item);
}
模糊查询
string str = Console.ReadLine();
var result = from f in food
where f.Contains(str)
select f;
foreach (var item in result)
{
Console.WriteLine(item);
}
分组 group
// from 语句
var srult = from fu in ulist
group fu by fu.username.Substring(0,2);
//遍历分组的数据
foreach (var item in srult)
{
Console.WriteLine("分组键是:{0}",item.Key);
foreach (var it in item)
Console.WriteLine("名字是:{0},年龄是:{1}",it.username,it.age);
}
联接 join