//14.First letter
private static void FirstLetter(GringottsContext grContext)
{
var letters = grContext.WizzardDeposits
.Where(d => d.DepositGroup == "Troll Chest")
.Select(w => w.FirstName)
.ToList().Select(fn => fn[0])
.Distinct()
.OrderBy(c => c);
foreach (var l in letters)
{
Console.WriteLine(l);
}
}
public static void Main(string[] args)
{
var grContext = new GringottsContext();
var context = new SoftUniEntities();
//FullInformation(context);
//SalaryOver(context);
//EmployeesFromSeattle(context);
//AddAddress(context);
//EmployeesInPeriod(context);
//AddressByTown(context);
//EmployeeWithId(context);
//DepartmentsWithMoreEmployees(context);
//FindLatestProjects(context);
//IncreaseSalary(context);
//FindEmployeeByFirstName(context);
//FirstLetter(grContext);
//DeletProject(context);
}
