public static void Main() { GringottsContext gringottsContext = new GringottsContext(); var wizards = gringottsContext.WizzardDeposits .Where(w => w.DepositGroup.Equals("Troll Chest")) .Select(w => w.FirstName.Substring(0, 1)) .Distinct(); foreach (var wiz in wizards) { Console.WriteLine(wiz); } }
static void Main(string[] args) { GringottsContext ctx = new GringottsContext(); var letters = ctx.WizzardDeposits .Where(w => w.DepositGroup == "Troll Chest") .ToArray() .Select(w => w.FirstName[0]) .Distinct() .OrderBy(w => w) .ToArray(); StringBuilder sb = new StringBuilder(); foreach (var l in letters) { sb.Append(l); sb.AppendLine(); } File.WriteAllText("../../out.txt", sb.ToString()); }