LinqDict

CSharp · Console

/Program.cs

using System;
using System.Collections.Generic;
using System.Linq;
					
public class Program {
  public static void Main()	{
    var input = new List<string> {
      "Location=COL&StockNumber=1111150416",
      "Location=NYC&StockNumber=2222250416&Invoice=Part",
      "Location=NYC&StockNumber=2222250416&Invoice=Part&Supplier=AutoZone"
    };
	  
	var output = input
      .SelectMany(line => line.Split('&'))
      .Select(item => item.Split('='))
      .GroupBy(pair => pair[0], pair => pair[1])
      .ToDictionary(group => group.Key, 
                    group => $"({string.Join(",", group.Distinct().Select(item => item.All(c => char.IsDigit(c)) ? item : "'" + item.Replace("'", "''") + "'"))})");  
	  
	// Let's have a look
	string report = string.Join(Environment.NewLine, output.Select(pair => $"{pair.Key,-12} : {pair.Value}"));
	  
	Console.Write(report);  
  }
}
;