Skip to main content

Microsoft Silverlight

Unanswered Question How to call query stored procedure in silverlight using ADO.NET Data service?RSS Feed

(0)

kent.zhou
kent.zhou

Member

Member

109 points

397 Posts

How to call query stored procedure in silverlight using ADO.NET Data service?

Please give a sample code to call query stored procedure in silverlight using ADO.NET Data service based on Entity framework.

I have tried a couple of times but failed. 

bryant
bryant

Star

Star

9937 points

1,629 Posts

Silverlight MVP

Re: How to call query stored procedure in silverlight using ADO.NET Data service?

Good overview of Entity Framework with ADO.Net Data Services here on Ian's blog, but doesn't have a stored proc example. However, there is a walk-through of using stored procs in EF here, so if you combine them together you should be able to get it working.

-- bryant

Blog | Twitter
_________________
Dont forget to click "Mark as Answer" on the post that helped you.

HarishSuhanda
HarishSu...

Member

Member

2 points

9 Posts

Re: How to call query stored procedure in silverlight using ADO.NET Data service?

Hi Thanks for the links,

Can someone help me to find out, how to call a Stored Procedure in Silverlight that returns data from multiple tables, that returns selected columns from a table and not the complete table.

In some post I find that we need to change the .edmx file manually. I believe this would be one of the biggest disadvantage of ADO.Net Data Services, in conjunction to Silverlight so far.

It is easy to work with WPF or Windows or Web Applications because we can directly query throught the .edmx file using LINQ to entities but it seems to be one of the biggest drawback for silverlight users.

Thanks,

Harish

If you find this post useful, mark it as an Answer

-Harish

bpoker
bpoker

Member

Member

5 points

11 Posts

Re: How to call query stored procedure in silverlight using ADO.NET Data service?

 Harish,

 

Were you ever able to resolve this issue? If so how?

 

Thanks!

  • Unanswered Question
  • Answered Question
  • Announcement
Microsoft Communities