Entity Framework and OData error

Former Member — Tue, 27 Oct 2020 05:10:55 GMT

Hi, I am experiencing a strange error while using SQL Anywhere .NET Framework provider with OData. I created a Web API application that exposes a standard OData GET query. Everything works fine using a simple api call like:

GET http://<ip>:<port>/odata/EOrder

It crashes when using:
http://<ip>:<port>/odata/EOrder?$select=<column list="">
Basically it seems failing every time I use some OQuery options.

It produces the following error

Message: "Cannot convert 'e4b8a7a6-d7c5-4adf-99ed-8bb046c3c8...' to integer"
Source: "SQL Anywhere .NET Data Provider"

Stacktrace
   at Sap.Data.SQLAnywhere.SACommand._ExecuteReader(CommandBehavior commandBehavior, Boolean isExecuteScalar, Boolean isBeginExecuteReader)
   at Sap.Data.SQLAnywhere.SACommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

Re: Entity Framework and OData error

Vlad — Fri, 30 Oct 2020 08:10:26 GMT

Do you have more information about the issue? E.g. table, schema, sample data, $metadata, how web service is designed, anything?!

If not, I suggest you to enable SQL traces and analyze logs. E.g. here https://sqlanywhere-forum.sap.com/questions/19508/how-to-logtrace-sql-statements or here: (-zr level) http://dcx.sap.com/sqla170/en/html/3bc8723c6c5f10149da5dc2f3b74259d.html

Question Re: Entity Framework and OData error in Technology Q&A

Entity Framework and OData error

Re: Entity Framework and OData error