locked
How to call Custom stored procedure from dynamics CRM 2011 RRS feed

  • 问题

  • 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.

    2011年11月16日 12:59

答案

  • 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
    2011年11月16日 13:42
  •  

    Updating the base table is unsupport.

     You would  have to use SDK  to update the entities

     

    • 已标记为答案 Alankar4u 2011年12月2日 5:25
    2011年11月16日 13:28

全部回复

  •  

    Updating the base table is unsupport.

     You would  have to use SDK  to update the entities

     

    • 已标记为答案 Alankar4u 2011年12月2日 5:25
    2011年11月16日 13:28
  • 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
    2011年11月16日 13:42
  • 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

    2011年11月17日 15:51
  • Yes, did the same. Thanks for reply.
    2011年12月2日 5:28
  • 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

    2012年6月22日 8:36