Which of the following Entity Framework queries is analogous to the SQL query to retrieve all employees with the last name 'Pérez'?

Which of the following Entity Framework queries is analogous to the SQL query to retrieve all employees with the last name 'Pérez'?

• A. from employee in Employees where employee.lname == 'Pérez' select employee
• B. Employees.Find(e => e.lname == 'Pérez')
• C. Employees.Log().Where(e => e.lastName == 'Pérez').ToList()
• D. Employees.Where(e => e.lname.Contains("Pérez")).ToList()

Answer: (A)

The query that retrieves all employees with the last name 'Pérez' in Entity Framework is well represented by the first option. This uses the LINQ (Language Integrated Query) syntax effectively, which is designed to look and feel much like SQL.

In this query, the from clause specifies that we are selecting from the Employees collection. The where clause filters this collection to only include those employees whose lname property matches the string 'Pérez'. The select clause then indicates that we want to output the entire employee object for those that satisfy this condition. This directly parallels the SQL where a SELECT query would filter results based on conditions outlined in a WHERE clause.

The other options either do not correctly filter or format the query in a way that would efficiently retrieve the employees by their last name. For instance, using Find with a predicate does not work the same way as a SQL-like query; it typically finds a single entity by its primary key, not multiple by a property. Similarly, including Contains in another answer would suggest a more flexible search that could also find last names containing 'Pérez', rather than specifically those that exactly match it.

Therefore, the first choice