How to call Custom stored procedure from dynamics CRM 2011

Answered 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
     
     Answered

     

    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
     
     Answered

    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 AM
     
     
    Yes, 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