Oracle Entity6 Duplicate data when querying view

When using Oracle + ENTITY6,

Encountered a problem, when querying the view, in the tool to execute the view SQL statement, is two different data.

But querying from entity is two identical data.

Viewed the edmx file,

Discover the object for view, and use several properties in the entity to define it as key.

This problem occurs if these keys are not sufficient to identify the uniqueness of the data.

Workaround:

Because the auto-defined key is not sufficient to identify the uniqueness of the data, it is necessary to add the attribute to the key so that the key's attribute group can uniquely identify the data

In the EDMX view, find the Class view of the corresponding view,

Right-click the attribute you want to add as key and select "Entity Key".

Oracle Entity6 Duplicate data when querying view