- A)
SELECT– retrieve some columns of a table - B)
SELECT– retrieve all columns from a table - C)
SELECT– sort the result set - D)
SELECT– group rows into groups example - E)
SELECT– filter groups example
ELINQ extends DbSet with a Query method. As any LINQ method, it accepts a Lambda. The Lambda parameters are the entities we want to participate in the query and return value is the result of SELECT invocation:
Retrieving some columns is not a common case in EF and requires declaration of the dedicated keyless entity (FullName).
Another option is to use LINQ for the anonymous top level projection. See how easy is to mix ELINQ and LINQ: