This is a migrated thread and some comments may be shown as answers.

Stored procedure returning a subset of columns

1 Answer 82 Views
Databases and Data Types
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
tmlipinski
Top achievements
Rank 1
tmlipinski asked on 06 Mar 2009, 11:06 AM
Hi,

When describing how to call a stored procedure, the documentation of OA says:
If a persistence-capable class is specified as result type, the columns selected in the sql statement must at least contain the primary key columns of the mapped result class, and additionally the discriminator column if defined and the version column(s) if defined.
It sounds reasonable - if PK is supplied all missing data can be supplemented (never mind the efficiency).
But I've made an experiment and prepared some SP that misses one of the columns (not PK / discriminator / version). And I've got a message: 
Error reading field PersistentClasses.Order.oREnteredByPRS from ResultSet: System.IndexOutOfRangeException
"oREnteredByPRS" corresponds to the missing column.
I'm using the 2008.3.1327.2 version of OA.

Regards
Tomasz

1 Answer, 1 is accepted

Sort by
0
Dimitar Kapitanov
Telerik team
answered on 10 Mar 2009, 07:35 AM
Hello tmlipinski,
Please check the Q1 2009 release when it is available, as we did quite a development in that direction, and probably this issue is fixed.

Regards,
Dimitar Kapitanov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Tags
Databases and Data Types
Asked by
tmlipinski
Top achievements
Rank 1
Answers by
Dimitar Kapitanov
Telerik team
Share this question
or