private static void FirstLetter(GringotsContext context) { var firstLetters = context .WizzardDeposits.Where(w => w.DepositGroup == "Troll Chest") .Select(w => w.FirstName.Substring(0, 1)) .Distinct().OrderBy(w => w) .ToList(); foreach (var letter in firstLetters) { Console.WriteLine(letter); } }
static void Main(string[] args) { var context = new GringotsContext(); //FirstLetter(context); }