locked
Can't expand results returned by a stored procedure RRS feed

  • Question

  • I have a stored procedure which returns a dataset that maps onto an entity. I imported the function and I can return the result set over my data service as a webget method. The problem is that I want to expand the result to include some values from the entity's parent.

     

    In other scenarios I can do things like

    1. Dim c = (from t in ctx.JobActions.Expand("Jobs"))

     

    This is pseudo code of calling a web get method

    2. Dim c as query(of JobActions) = http://localhost/ds.svc/jobresults?$expand=Jobs

     

    How do I tell the web method to expand the stored proc resultset. Can I do some kind of join in the webmethod?

     

    Regards, Chris.

    Monday, November 24, 2008 10:15 PM

Answers

  • WebMethods are black box to the data service. You can do whatever you want inside it (sure you can do join if the underlying provider allows you to do so). We will try and serialize the results out and if you have expand query parameter provided in the request uri, then we will try and serialize out the nested entity results.

     

    Did I answer your question?

     

    Thanks

    Pratik

     

     

    Monday, December 1, 2008 7:28 PM
    Moderator