子句jion

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace 子句join
{
    
    class Program
    {
        static void Main(string[] args)
        {
            List<Person> listPerson = new List<Person>();
            listPerson.Add(new Person(1,"张1",1));
            listPerson.Add(new Person(2,"张2",2));
            listPerson.Add(new Person(3,"张3",2));
            listPerson.Add(new Person(4,"张4",4));

            List<Car> listCar = new List<Car>();
            listCar.Add(new Car(1,"宝马"));
            listCar.Add(new Car(2, "雷霆"));
            listCar.Add(new Car(3, "海马"));
            var query1 = from itemlistPerson in listPerson from itemlistCar in listCar where itemlistPerson.CarId == itemlistCar.Id select itemlistPerson;
            foreach (var item in query1) 
            { 
                Console.WriteLine(item.CarId.ToString()+" "+item.Name.ToString());
                Console.ReadKey();
            }
        }
    }
}
原文地址:https://www.cnblogs.com/cnshuji/p/5446645.html