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

narasimhaadityac

A Score Level 2

over 7 years ago

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?

Discussion posts and replies are publicly visible

Parents

0 Chris over 7 years ago

Also with MS SQL you can use a column such as this to define a unique ID on a view:

"SELECT TOP (100) PERCENT ROW_NUMBER() OVER (ORDER BY <any column>) AS Row, ..."

That will create a column 'Row' as a unique value. Only trick from there is your XSD will need to define this column as 'bigint'.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Chris over 7 years ago

Also with MS SQL you can use a column such as this to define a unique ID on a view:

"SELECT TOP (100) PERCENT ROW_NUMBER() OVER (ORDER BY <any column>) AS Row, ..."

That will create a column 'Row' as a unique value. Only trick from there is your XSD will need to define this column as 'bigint'.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data