Join on substring : Join « LINQ « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. LINQ
3. Join

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;


public class MainClass{

   public static void Main(string[] args){   
         String[] QueryString = { "One", "Two", "Three", "Four", "Five",
              "Six", "Seven", "Eight", "Nine", "Ten" };

         String[] IndexArray = { "A", "B", "C", "D", "E", "F", "G", "H", "I",
              "J", "K", "L", "M", "N", "O", "P", "Q", "R",
              "S", "T", "U", "V", "W", "X", "Y", "Z" };

         var ThisQuery = from StringValue in QueryString 
            join IndexValue in IndexArray
            on StringValue.Substring(0, 1) equals IndexValue
            select new {StringValue, IndexValue};


         foreach (var ThisValue in ThisQuery)
            Console.WriteLine(ThisValue.IndexValue + " - " + 
               ThisValue.StringValue);

   }
}