ORM examples

ormexamples.cs

internal IEnumerable<Employee> GetEmployees1(string lastName) {
    var query = 
        from emp in context.Employee
        where emp.LastName.StartsWith(lastName)
        orderby emp.LastName, emp.FirstName
        select new Employee {
            Id = emp.Id,
            Name = emp.FirstName + ' ' + emp.LastName,
            FavoriteColor = emp.FavoriteColor ?? "Green"
        };
    return query.ToList();
}

internal IEnumerable<Employee> GetEmployees2(string lastName) {
    var query = 
        context.Employee
        .Where(emp => emp.LastName.StartsWith(lastName))
        .OrderBy(emp => emp.LastName)
        .ThenBy(emp => emp.FirstName)
        .Select(emp => new Employee {
            Id = emp.Id,
            Name = emp.FirstName + ' ' + emp.LastName,
            FavoriteColor = emp.FavoriteColor ?? "Green"
        });
    return query.ToList();
}