Say I have a stored proc and two tables in a SQL Server DB. I want to expose the data in the tables to SF. That I can achieve by creating a oData service in, say, .NET and expose the tables. Lightning connect will use the endpoint exposed by the oData service and create two External objects one for each table.
Now, I also want the functionality of the stored proc be available in SF.
-Can I expose the SP as a oData service and consume that in Salesforce via Lightning connect?
-If not what are the options available to me reuse the Stored proc functionality using Lightning Connect?