I'd like to get some data from my SQL database. But the problem is I can't use the port number in a connection string like I have to avoid it normally due to a firewall. Currently, my SQL server is like a black box that only my sharepoint Server can query. due to IT security, only sharepoint servers are allowed to submit queries to my DB.(Like Stored procedure)
I think I have to create a web service which collects the data from my DB and return it, but how could I do that on Visual Studio?
I'm totally lost, after some searches, I think I have to do a WCF. So if I understand well, I have to use my sharepoint server to hosted my WCF and after that my server could request my Database and send the information to my client (C# application). Is it right? So if someone could have some tips to help me, It would be appreciated.