I have no problem generating an .edmx file for an MVC project I am working on. It involves one table and one view. However, EF decides on the primary key, which is actually a unique value each row, but I was hoping to make a text field the primary key because that is what I search on. It has unique values.
Error 6002: The table/view 'DWS.dbo.InventoryTiny' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view. C:\DWS\DWS\DWS.edmx
Read-only is ok. But I would like to change the primary key to a different column. How do I do that and this humble idiot thanks you in advance.