Search code examples
entity-framework-6sql-server-2014columnstore

Clustered Columnstore with Entity Framework


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?


Solution

  • The answer is to add a key to the edmx. Open the EDMX, right click the column and select entity key