c# linq语法

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; }
    }



   

     
}