Take advantage of query types in EF Core to query types that don’t have keys and to map to tables and views that lack an identity column.

SQL Basics I: Data Queries —covers database terminology and the four basic query types. SQL Basics: SELECT statement options —covers the SELECT statement in detail and explains aggregate ...