Click here to Skip to main content
15,919,028 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

I have a simple requirement to be implemented on a silverlight app. I want to list down all the stored procs in a drop down and view its output on a grid. I am currently having a WCF service where I have drag dropped all the stored procs I want to view and generated the classes on a .dbml file. This works for me at the moment. However, if I have a new stored proc, I am forced to generate the class and update the service again.

Is there a way to view the results of the stored proc without updating the service everytime? I was thinking of using DataContext.ExecuteCommand Method but not sure if there is a much better way to do this.
Updated 19-Oct-10 7:32am

1 solution

Updating the service everytime is definitely not the recommended way.

I would recommend you change your strategy to get all the stored procedures. Write a query to get all the stored procedures. Let your WCF service return this list by querying the database.

Then let Silverlight display this list in a combo.
Share this answer
Abhinav S 19-Oct-10 13:35pm    
From dudehari - "The main issue I am facing is not with the querying of sps in the database. Each of these sps have different auto generated output resultset. I wanted to handle this varied result sets from the wcf service in a generic way."

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900