CSharp · Console
using System;
using System.Linq;
using System.Collections.Generic;
public class Program
{
public static void Main()
{
// prepare data
var first = new List<Region>() { new Region(1), new Region(3), new Region(4) }; // Left data
var second = new List<Region>() {
new Region(1, "Eastern"), new Region(2, "Western"),
new Region(3, "Northern"), new Region(4, "Southern")
}; // Right data
// do the inner join
var result = from f in first
join s in second on f.ID equals s.ID
select new { f.ID, s.RegionDescription };
// print results
foreach(var s in result)
{
Console.WriteLine($"ID={s.ID}, Region='{s.RegionDescription}'");
}
}
}
// a data structure suitable for join demo: Primary key=ID
public class Region {
public Int32 ID;
public string RegionDescription;
public Region(Int32 pRegionID, string pRegionDescription=null)
{
ID=pRegionID; RegionDescription=pRegionDescription;
}
}