Exception when Updating/Inserting data using OData service in ASP.NET web application

Question

User145606326 posted

Hi,

We are trying to integrate SAP's Hana db and ASP.NET web application. We have successfully fetched the data from db using OData service but when we are trying to perform insert, update and delete operations, it is throwing exception "Feature not supported". The Odata service, we are using, is not a WCF service. It is created in SAP Hana Studio having URL "http://<HANAServerName>:<port number>/<Folder structure>/TestXS.xsodata". We have checked the insert, update, delete and select operation using OData service with the "POSTMAN" application.

Please guide on this.

Thanks,
Varun

Answer 1

User220959680 posted

Is the service exposed as REST?

How the service is accessed in ASP.NET Web application? In other words ' how the request to the OData service is made from ASP.NET Web application.

Refer http://scn.sap.com/community/developer-center/hana/blog/2012/11/29/sap-hana-extended-application-services

Answer 2

User145606326 posted

Hi,

Thanks for the reply.

The OData service is exposed as REST.

I am adding service reference of that service in my web application and then use the service by making the context. It is throwing exception when I am trying to save changes by calling context.SaveChanges() method.

Thanks,

Varun

Answer 3

User220959680 posted

adding service reference of that service in my web application and then use the service by making the context. It is throwing exception when I am trying to save changes by calling context.SaveChanges() method.

Note that for REST service it is NOT requried to add web service reference to generate a proxy. 

It is only the case for SOAP (Simple Object Application protocol) to generate a proxy on client side .

Any client that can make Http calls can invoke the REST service such as browser (IE, Chrome etc), Fiddler.

http://www.odata.org/