namespace linq
{
class Program
{
static void Main(string[] args)
{
//linQ语法
//int[] a = new int[] { 12, 5, 9, 7, 8 };
//var xx = from i in a
// where 1 % 2 == 0
// select i;//linq语法
//var yy = a//方法
// .Where(p => p % 2 == 0)
// .OrderByDescending(p => p)//排序
// .Select(p => p * 2 +1);
//赋值
Person[] persons = new Person[]
{
new Person{ CityID = 1, Name = "ABC" },
new Person{ CityID = 1, Name = "EFG" },
new Person{ CityID = 2, Name = "HIJ" },
new Person{ CityID = 3, Name = "KLM" },
new Person{ CityID = 3, Name = "NOP" },
new Person{ CityID = 4, Name = "QRS" },
new Person{ CityID = 5, Name = "TUV" }
};
//赋值
City[] cities = new City[]
{
new City{ ID = 1,Name = "Guangzhou" },
new City{ ID = 2,Name = "Shenzhen" },
new City{ ID = 3,Name = "Beijing" },
new City{ ID = 4,Name = "Shanghai" }
};
//两表连接 linQ语法
var ss = (from p in persons
join c in cities on p.CityID equals c.ID
select new
{
PersonName = p.Name,
CityName = c.Name
}).ToList();
foreach (var item in ss)
{
Console.WriteLine(item.PersonName + "+" + item.CityName);
}
Console.Read();
}
}
//人表
class Person
{
public int CityID { set; get; }
public string Name { set; get; }
}
//城市表
class City
{
public int ID { set; get; }
public string Name { set; get; }
}
}
c# linq语法
最新推荐文章于 2024-08-12 00:25:11 发布