WCF Data Services & EF - how to call an update stored procedure that does NOT deal with an entity
-
I've googled and binged and still feel wholly ignorant I tend the database side of a 'system' or process that our clients update by GETting task info from our web service into an Excel spreadsheet. As tasks are completed, they use a different tab on the spreadsheet to POST info on the task back through the web service. The web service is written in Delphi and hits stored procedures for both the GET and POST. FWIW, I don't have access to the Delphi source code. I'd like to learn to do some of this in .Net/C# and I have access to VS2013. The GET side returns what LINQ would consider a projection, so there is no 'entity' model in EF, just a complex type. I can duplicate the results of the GET using WCF Data Services. The POST side should talk to a stored procedure that requires a number of parameters that are likewise not an entity, but an amalgam of properties from a couple of SQL tables. This is where I cannot figure things out and can't find any discussion of anything similar. First, the vast majority of examples deal with querying an OData service and the few that deal with POSTing all assume you're creating a new ENTITY or updating an existing one. So, finally, the question: can anybody tell me if what I'd like to do is even possible with WCF Data Services & EF and, if so, in general terms HOW. If the answer is that I can't do this in WCF DS & EF, then what do you recommend as the means by which I can learn how to do this, and actually accomplish it?