I'd like to get some data from my SQL database and use it in my visual studio project. But the problem is I can't use the port number in a connection string like I have to do 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) and use these data in my visual studio application.
I'm totally lost, after some searches, two things look like possible: WCF or BCS? For you, what would it be the easiest and the fastest way to deploy this solution? and how?
Many thanks in advance for your help