I am trying to import a view into my edmx model. The problem I am having is that it does not find a valid identifier for the view. I have previously imported a different view (in which I included the primary key of the attributes that are present in the view, and in this case the primary key was inferred correctly). However, in the new view I am trying to import, it is not possible to include the primary key in the view.
The view is simple:
SELECT DISTINCT Attr1
And since I am selecting "DISTINCT" values, really there shouldn't be any duplicate values in the table anyway. How can I solve this issue?
View Complete Post