I was doing a few experiments with OpenAccess and the various Services that can be produced with the data service wizard. I stared with a simple database, and the Astoria data service wizard template. This all worked pretty well and I was able to use the service in Silver-light. Now, I wanted to add a stored procedure that returned a collection of entities, and I am not seeing how to do that :(.
The stored procedure is present in the Model Schema Explorer, but there does not appear to be any way to create a Function mapping using this designer, is there?
I assume its possible to create and expose method interfaces as well as the entity linq interfaces using the Astora services, eg say I wanted to expose a GetSomeEntitySet(int param1, int param2) as a method accessible from the Silverlight client using the Astora model. I did attempt a few things to make this work, but have not been successful so far. Anyway, this would be important, as I am trying to create some plumbing to expose a stored procedure call that returns entities to a Silverlight client.
Any ideas would be appreciated.
I am using OA Version: 2010.1.527.2