Exemple #1
0
        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);
        }