С# Линк. Присоединяйтесь к коллекциям по ID ⇐ C#

[Anonymous]

У меня есть три коллекции с общим ключом:
var shops = new[] { new { shopId = "1", shopName = "shop1" }, new { shopId = "2", shopName = "shop2" } , new { shopId = "3", shopName = "shop3" }};
var sales = new[] { new { shopId = "1", sales = "1000", place = 2 }, new { shopId = "2", sales = "0", place = 1 } , new { shopId = "3", sales = "100", place = 3 }};
var unpostedChecks = new[] { new { shopId = "1", checkQnt = 2 }};

Как мне объединить эти коллекции, используя C# LINQ, чтобы получить такой результат?:
var result = new[] {
new { shopId = "1", shopName = "shop1", sales = "1000", place = 2, checkQnt = 2 },
new { shopId = "2", shopName = "shop2", place = 1 , sales = 0, checkQnt = 0},
new { shopId = "3", shopName = "shop3", sales = "100", place = 3 , checkQnt = 0}
};


Подробнее здесь: https://stackoverflow.com/questions/792 ... ions-by-id