public static void Main(string[] args)
{
var context = new SoftUniEntities();
var employeeNames = context.Employees
.Where(e => e.Salary > 50000)
.Select(e => new
{
e.FirstName,
e.LastName,
e.Salary
})
.OrderBy(e => e.Salary)
.ToList();
employeeNames.ForEach(Console.WriteLine);
var employeesFromSeattle = context.Employees
.Where(e => e.Department.Name == "Research and Development")
.OrderBy(e => e.Salary)
.ThenByDescending(e => e.FirstName)
.Select(e => new
{
e.FirstName,
e.LastName,
e.Department.Name,
e.Salary
})
.ToList();
employeesFromSeattle.ForEach(e => Console.WriteLine("{0} {1} from {2} - ${3}",
e.FirstName, e.LastName, e.Name, e.Salary));
var address = new Address()
{
AddressText = "Vitoshka 15",
TownID = 4
};
context.Addresses.Add(address);
context.SaveChanges();
}
public static void Main(string[] args)
{
var context = new SoftUniEntities();
var employeeNames = context.Employees
.Where(e => e.Salary > 50000)
.Select(e => new
{
e.FirstName,
e.LastName,
e.Salary
})
.OrderBy(e => e.Salary)
.ToList();
employeeNames.ForEach(Console.WriteLine);
var employeesFromSeattle = context.Employees
.Where(e => e.Department.Name == "Research and Development")
.OrderBy(e => e.Salary)
.ThenByDescending(e => e.FirstName)
.Select(e => new
{
e.FirstName,
e.LastName,
e.Department.Name,
e.Salary
})
.ToList();
employeesFromSeattle.ForEach(e => Console.WriteLine("{0} {1} from {2} - ${3}",
e.FirstName, e.LastName, e.Name, e.Salary));
var address = new Address()
{
AddressText = "Vitoshka 15",
TownID = 4
};
context.Addresses.Add(address);
context.SaveChanges();
}
