public static void GetFirstName(GringottsContext context) { var wizards = context.WizzardDeposits .Where(w => w.DepositGroup == "Troll Chest") .Select(w => w.FirstName.Substring(0, 1)) .Distinct() .OrderBy(w => w); foreach (var w in wizards) { Console.WriteLine(w); } }
static void Main(string[] args) { SoftUniContext context = new SoftUniContext(); GringottsContext contextG = new GringottsContext(); //AllEmployyes(context); //EmpWithSalaray.EmpWithSalara500(context); //EmpFromSeatle.EmpsFromSeattle(context); //AddAddressUpdEmp.AddingAdressUpdateEmp(context); //FindEmpPeriod.EmployeesInPeriod(context); //AdressesByTownName.GetAdressesByTownName(context); //EmployeesId147.GetEmployeeId(context); //DepartmentsMoreThan5Emp.GetDepartmentsMoreThan5Emp(context); //FindLatest10Projects.GetLatest10Projects(context); //IncreaseSalaries.GetIncreaseSalaries(context); //FIndEmpFirstName.GetEmpFirstNameSA(context); //FirstLetter.GetFirstName(contextG); //DeleteProejctById.GetDeletePrejctById(context); DeleteTown.GetDeleteTown(context); //NativSQL.GetNativeSql(context); }