I am trying to execute SQL stored procedure from C# code using Sitecore data providers. I am using the SqlDataApi class from Sitecore.Data.DataProviders.Sql but not finding any method which accepts a stored procedure name as an input parameter.

Kindly help on this if somebody did it in any Sitecore project.

  • 1
    For what reason do you need to use that API? Why not just use the standard .Net APIs? – Michael West Dec 9 '19 at 17:21
  • Actually I am accessing form database using SqlDataApi. To use .Net APIs I need to open a new connection of form data base which I don't want. Because I already open a connection to access data base using SqlDataApi. – Sharjeel Bilali Dec 10 '19 at 10:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.