I have a table with a Clustered Columnstore index. This table cannot have a primary key because of the index. It actually has an ID column, but I cannot put an index on it. Entity Framework demands a Key, otherwise it marks it as read only. How can I tell EF what the key is?
The answer is to add a key to the edmx. Open the EDMX, right click the column and select entity key