27 在查询中使用Lambda表达式

 

    class Program
    {
        static void Main(string[] args)
        {
            List<Company> companyList = new List<Company>()
            {
                new Company() { CompanyID = 1, Name = "sun" }
            };
            List<Person> personList = new List<Person>()
            {
                new Person() { Name = "Allen", CompanyID = 1 }
            };
            var personWithCompanyList = from person in personList
                                        join company in companyList on person.CompanyID equals company.CompanyID
                                        select new { PersonName = person.Name, CompanyName = company.Name };

            foreach (var item in personList.Select(person => new { PersonName = person.Name, CompanyName = person.CompanyID == 0 ? "M" : "Sun" }))
            {
                Console.WriteLine(string.Format("{0}\t:{1}", item.PersonName, item.CompanyName));
            }
        }
        class Person
        {
            public string Name { get; set; }
            public int CompanyID { get; set; }
        }
        class Company
        {
            public int CompanyID { get; set; }
            public string Name { get; set; }
        }
    }