CSHARP

linq from select

List<Employee> emps = (from e in _dbContext.Employees where e.person_id == personId select e).ToList();

linq select

IEnumerable<SelectListItem> stores =
        from store in database.Stores
        where store.CompanyID == curCompany.ID
        select new SelectListItem { Value = store.Name, Text = store.ID };