Linq_Join_Example

CSharp · Console

/Program.cs

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;
	}
}
;