Linq 左连接报错未将对象引用到实例及多条件联立

1. 多条件连接

当两张表必须用多个字段来作为关键值进行连接时，我们可以用

on new
 {
	Number = i.PO_No,
	Name = i.Name,
	Plan = i.Plan,
	Code = i.Code
} equals new
 {
    Number = k.Number,
    Name = k.Name ,
    Plan = k.Plan,
    Code = k.Code
}

2. linq 左连接

关键语

//在需要左连接的表后加上 into gjfrom subpet in gj.DefaultIfEmpty()
var query = from person in people
                join pet in pets on person equals pet.Owner into gj
                from subpet in gj.DefaultIfEmpty()
//subpet 是新构造的，不要写成 pet 或 person
//否则会报“未将对象引用到实例”的错误，因为最终的查询是从subpet里查找，如果写成 pet 就会查到空值
//在 select 里也要对可能为 null 值的字段进行预处理用 ?? 赋值

例：

class Person
{
    public string FirstName { get; set; }
    public string LastName { get; set; }
}

class Pet
{
    public string Name { get; set; }
    public Person Owner { get; set; }
}

public static void LeftOuterJoinExample()
{
    Person magnus = new Person { FirstName = "Magnus", LastName = "Hedlund" };
    Person terry = new Person { FirstName = "Terry", LastName = "Adams" };
    Person charlotte = new Person { FirstName = "Charlotte", LastName = "Weiss" };
    Person arlene = new Person { FirstName = "Arlene", LastName = "Huff" };

    Pet barley = new Pet { Name = "Barley", Owner = terry };
    Pet boots = new Pet { Name = "Boots", Owner = terry };
    Pet whiskers = new Pet { Name = "Whiskers", Owner = charlotte };
    Pet bluemoon = new Pet { Name = "Blue Moon", Owner = terry };
    Pet daisy = new Pet { Name = "Daisy", Owner = magnus };

    // Create two lists.
    List<Person> people = new List<Person> { magnus, terry, charlotte, arlene };
    List<Pet> pets = new List<Pet> { barley, boots, whiskers, bluemoon, daisy };

    var query = from person in people
                join pet in pets on person equals pet.Owner into gj
                from subpet in gj.DefaultIfEmpty()
                select new { person.FirstName, PetName = subpet?.Name ?? String.Empty };

    foreach (var v in query)
    {
        Console.WriteLine($"{v.FirstName+":",-15}{v.PetName}");
    }
}

// This code produces the following output:
//
// Magnus:        Daisy
// Terry:         Barley
// Terry:         Boots
// Terry:         Blue Moon
// Charlotte:     Whiskers
// Arlene: