Entity Framework requires primary keys for entities. But we can use the below type of query.var seasons = db.Schedules.SqlQuery("SELECT DISTINCT Season FROM Schedule").TList();

The Entity framework will not support to have a table without primary key, but we can overcome this issue by accessing the table with additional column via a view and marking the new column as Primary in entity framework.