I have few oracle tables without primary keys.I cannot modify this database design,since it is used by several applications. Adding an Auto increment field is also not an option.
In order to generate Edmx in Entity Framework I need a unique field in the table. So what I'm trying to do is creating a view with an unique key.
My table is like :

CREATE TABLE "ENTITLEMENTS" ( "TOKEN" VARCHAR2(40 CHAR), "ENROLLED_FUNCTION" VARCHAR2(9 CHAR) ); Is there a way to show an auto generated identity field from a view. If so how?


view solution