How to call Custom stored procedure from dynamics CRM 2011
-
Wednesday, November 16, 2011 12:59 PM
I have one stord procedure which uploads bulk data in CRM entities, i need to trigger stored procedure from Dynamic CRM on button click.
How can i do it or what is the best approach to call stroed procedure from Dynamic CRM 2011.
All Replies
-
Wednesday, November 16, 2011 1:28 PM
Updating the base table is unsupport.
You would have to use SDK to update the entities
- Marked As Answer by Alankar4u Friday, December 02, 2011 5:25 AM
-
Wednesday, November 16, 2011 1:42 PM
1st, you can not update the data directly
2nd, if you have to do that for some reason such as performance or anything else, write a wcf service, coding javascript function to call the service and then trigger the stored procedure.
daemon lin- Proposed As Answer by Andrey Vishnevsky Wednesday, November 16, 2011 6:29 PM
- Marked As Answer by Alankar4u Friday, December 02, 2011 5:27 AM
-
Thursday, November 17, 2011 3:51 PM
Hi Alankar
Did this help?
Please make sure to mark as answer to the response that helped you get through. This will help others with similar problem identify the answer and also close this thread as resolved.
Thanks
Dk
-
Friday, December 02, 2011 5:28 AMYes, did the same. Thanks for reply.
-
Friday, June 22, 2012 8:36 AM
Hi
I am having the same issue, i have already build my store proc in sql server, grateful if someone can guide me on how to write a wcf service then using java-script to call the web service
Thanks