This is regarding the CDT's. We have a database view and there is no d

This is regarding the CDT's.
We have a database view and there is no defined identifier column hence we have defined one of the column as primary key while defining CDT. We observed that there are duplicate entries coming up for this column defined as primary key.
When using "Query Rule" the duplicates are eliminated and it is showing only one row
When using "Query Entity" we are been returned with all entries and its not honoring the primary key column.

Any idea on why this difference in behaviors?

OriginalPostID-215718

OriginalPostID-215718