Stored procedure returning a subset of columns

2 posts, 0 answers
  1. tmlipinski
    tmlipinski avatar
    131 posts
    Member since:
    Dec 2006

    Posted 06 Mar 2009 Link to this post

    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
  2. Dimitar Kapitanov
    Admin
    Dimitar Kapitanov avatar
    632 posts

    Posted 10 Mar 2009 Link to this post

    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.
  3. DevCraft banner
Back to Top