Can I use GearHost api to call mssql stored procedures?

Can I use the GearHost API to call stored procedures in my mssql database?
I am really trying to figure out what is the best way of accessing my data for a website?

1 Like

Use nuget package Dapper search on google.

Depending on what type of app you installed when you created your website, either ASP.NET or PHP. Both languages have classes and methods that you would use to call procedures in your database.

This link shows how to use MySQL with PHP: https://secure.php.net/manual/en/mysqli.quickstart.stored-procedures.php

I am sure you can search the site to explain how to use it with MSSQL.

This is how you do it in ASP.NET MVC: https://www.aspsnippets.com/Articles/ASPNet-MVC-Call-Stored-Procedure-using-Entity-Framework.aspx