Using stored procedures

Question

Hello,

My OData WCF Service uses stored procedure due to its performance. However, I found that DataMarket currently doesn't support stored procedure.

- Why doesn't DataMarket support stored procedure?

- Are you planning to support stored procedure?

- Could you please give any technical advice on my OData WCF Service if I have to change the way of getting data from databases if I give you more detail information?

Thanks,

Sung Am

Answer 1

Hi,

For supporting SP, you can vote it as new feature: http://www.mygreatwindowsazureidea.com/forums/34192-windows-azure-feature-voting

For accessing database you can use Entity Framework Provider to Connect to SQL Database:

http://msdn.microsoft.com/en-us/library/windowsazure/hh689718.aspx#efprovider

Thanks,

---

QinDian Tang
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.