Re: Interacting with a Page Web Service (OData v4) Error - C# Discussion Boards

Hi!
I have published a Microsoft Dynamics NAV page as an OData web service V4.
I used Odata v4 Client Code Genrator ver 2.4.0 to create the Client side proxy classes for my C# project.
When I make a simple call to "myhost/.../Company" everything works like a charm using simple code like this:

C#

NAVCient = new NAVEntities.NAV(new Uri("myhost/.../ODataV4"));
NAVCient.Credentials = new Net.NetworkCredential("usr", "psw");
List<NAVEntities.Company> company = NAVCient.Company.ToList;

I get my list of available Companies. Now I want to get the CustomerCards for my selected Company. I do like this:

C#

NAVCient = new NAVEntities.NAV(new Uri("myhost/.../ODataV4/Company('MyTest')")); 
NAVCient.Credentials = new Net.NetworkCredential("usr", "psw"); 
List<NAVEntities.Customer_Card> Customers = NAVCient.Customer_Card.ToList;

The uri genrated is correct and I can see the response comming back correct using fiddler with all my data. Code gets an exception trying to parse the information. At first i thought the backend had some issues but clearly its the client producing this error bec in fiddler I can see my result and nothing else as a response from server :

"An unhandled exception of type 'Microsoft.OData.Core.ODataException' occurred in Microsoft.OData.Core.dll
Additional information: When writing a JSON response, a user model must be specified and the entity set and entity type must be passed to the ODataMessageWriter.CreateODataEntryWriter method or the ODataFeedAndEntrySerializationInfo must be set on the ODataEntry or ODataFeed that is being written."

Any suggestions/advice?
I have tried other sources and they work as it seem.
Thanks for your help
// henrik
Tags:

You haven't said specifically which statement is failing.

I would try:

var Customers = NAVCient.Customer_Card;
... = Customers.ToList();
etc.

instead of:

List<NAVEntities.Customer_Card> Customers = NAVCient.Customer_Card.ToList;

And see how far I get from there.

"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal

It is failing on the .ToList part ...
Its very wierd. Tried that thing but same. And wierdest of all why is it trying to write a JSON-response? Sounds more like something from server?

That was the point.

Inspect the "var" using the debugger before performing the "ToList" and see what you're getting versus what you're expecting.

"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal

Will take a look into it ...
Getting back to you!

The object returned is :

Microsoft.OData.Client.DataServiceQuery(Of Customer_Card)

The object created by the Client generator. I need to call .Execute or something else with collection to
make it execute the query.

If I do that I get :

Microsoft.OData.Client.QueryOperationResponse(Of Customer_Card)

The execution seem ok. Problem is when I start enumerating through the list that shold have been produced. I can clearly see in fiddler that result comming back to me is ok. Something is happening on clientside. Maybe the call itself to the service is doing something wierd. But why should it do that when it works on the query for Company.

Can this has to do with child/relations spec maybe?

Thanks ZD

You say execution "seems ok" .... Hardly a show of confidence.

Instead of assuming it is "ok", there are a number of properties in the response you should look at (e.g. "Error") to confirm that everything is as it should be.

QueryOperationResponse Class (System.Data.Services.Client)

"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal

Trying executing .Execute on the object of type :

Global.Microsoft.OData.Client.DataServiceQuery(Of Customer_Card)

Gives me this object and I can see in fiddler that response is received and correct but accoring to error TotalCount is missing:
https://postimg.org/image/eyv1hglnj/
However I got the objext I am supposed to.

If I try to call .ToList it first makes call to .Execute and then try to create :

System.Collections.Generic.List(Of NAVEntities.Customer_Card)

But it produces an error and I the object looking like this:
https://postimg.org/image/e3ewt9b5j/

Full stacktrace is:

Microsoft.OData.Core.ODataException was unhandled
  HResult=-2146233079
  Message=When writing a JSON response, a user model must be specified and the entity set and entity type must be passed to the ODataMessageWriter.CreateODataEntryWriter method or the 
  ODataFeedAndEntrySerializationInfo must be set on the ODataEntry or ODataFeed that is being written.
  Source=Microsoft.OData.Core
  StackTrace:
       at Microsoft.OData.Core.ODataFeedAndEntryTypeContext.ValidateAndReturn[T](T value)
       at Microsoft.OData.Core.ODataFeedAndEntryTypeContext.get_NavigationSourceName()
       at Microsoft.OData.Core.Evaluation.ODataConventionalEntityMetadataBuilder.ComputeId()
       at Microsoft.OData.Core.Evaluation.ODataConventionalEntityMetadataBuilder.ComputeAndCacheId()
       at Microsoft.OData.Core.Evaluation.ODataConventionalEntityMetadataBuilder.GetId()
       at Microsoft.OData.Client.Materialization.MaterializerEntry.UpdateEntityDescriptor()
       at Microsoft.OData.Client.Materialization.FeedAndEntryMaterializerAdapter.ReadEntryCore()
       at Microsoft.OData.Client.Materialization.FeedAndEntryMaterializerAdapter.TryReadEntry(MaterializerEntry& entry)
       at Microsoft.OData.Client.Materialization.FeedAndEntryMaterializerAdapter.<LazyReadEntries>d__0.MoveNext()
       at Microsoft.OData.Client.Materialization.FeedAndEntryMaterializerAdapter.Read()
       at Microsoft.OData.Client.Materialization.ODataReaderEntityMaterializer.ReadNextFeedOrEntry()
       at Microsoft.OData.Client.Materialization.ODataEntityMaterializer.ReadImplementation()
       at Microsoft.OData.Client.MaterializeAtom.MoveNextInternal()
       at Microsoft.OData.Client.MaterializeAtom.MoveNext()
       at System.Linq.Enumerable.<CastIterator>d__94`1.MoveNext()
       at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
       at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
       at Data.WebServices.ODataTestApp.MainModule.Main() in Data.WebServices.OData.TestApp\MainModule.cs:line 19
       at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
       at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
       at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
       at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()
  InnerException:

Update : I Have error on TotalCount on the Company-call that worked so thats not the case.

modified 5-Jan-17 1:26am.

Unfortunately, you're posting "code fragments"; which makes it hard to discern what you are or are not doing.

You previously hinted it might be a "relation" thing; yes, data services does "lazy loading"; cannot tell from your post if you addressed this.

How to: Load Related Entities (WCF Data Services)

"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal

Lets see if I can put up a sample thing for you.

Yes lazyloading might be a thing just like in EF. Need to turn it off maybe?

Thanks // zd

Cant see anything in fiddler that draws me into that relation-direction. Its just plain-data. Have to dive deeper into that.

I'm thinking the possibility that from Main () can access its copy of Name_Common to do Name_Common.Cls_Common.StCommon = new Name_Common.St_Common(); For now I do not know how to do it because there is an error. So when I want to use a class, I can copy Main's global structure to that of the class. I have remembered that I did a function to make (cast) of one estrcuture to another one.

For now I can not make new Name_Common.St_Common(); of Main(). The brain has stopped me for days. I can also someone something about points 2 and 3 of debugger employment? Thank you.

What has this got to do with this question? Please don't hijack others posts.

This space for rent

Perhaps only using a Browser for now will help to clarify what is going on:

Accessing the Service from a Web Browser (WCF Data Services Quickstart)

I suggest you try it.

"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal

I am on to it ...
Getting back ...
//zd

Everything ok with browsing the service. Filtering etc work like a charm. This is for sure client-issue.

I have tried to generate proxyclasses using 2 different tools that state they can produce proxy for OData v4.

If I try to use Add Service Reference I get en error like this :

Quote:
The document at the url file:///e:/client.xml was not recognized as a known document type.
The error message from each known type may help you fix the problem:
- Report from 'XML Schema' is 'The root element of a W3C XML Schema should be <schema> and its namespace should be 'http://www.w3.org/2001/XMLSchema'.'.
- Report from 'DISCO Document' is 'Discovery document at the URL file:///e:/client.xml could not be found.'.
- The document format is not recognized.
- Report from 'WSDL Document' is 'There is an error in XML document (2, 2).'.
- <edmx xmlns="http://docs.oasis-open.org/odata/ns/edmx"> was not expected.
If the service is defined in the current solution, try building the solution and adding the service reference again.

Guess That built in proxyclass generator only handles up to V3?

This is what my Schema look like:

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="4.0" xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx">
  <edmx:DataServices>
    <Schema Namespace="NAV" xmlns="http://docs.oasis-open.org/odata/ns/edm">

Thanks

Yes; when your previously mentioned you used a "generator" .... It's almost a given you will have less control and less transparency.

I usually go "down to the metal" first time around; and then I MAY go "fancy".

OData - the Best Way to REST

Home · object/Simple.OData.Client Wiki · GitHub

"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal

Thanks Gerry ...
yes I dont like it either but client wanted an easy way to code against Microsoft Dynamics.

I have been all over that Odata-site and everything work as intended if you do it the raw way,

I do like the look of Simple.OData.Client. Maybe try it out. Have you tested it?

We are sending in the question to NAV developement team to see if they have any answer to why it dont work with a generator.

Thanks for all your help Wink | ;)

You're welcome.

No, I haven't tried "Simple.OData.Client"; but it has a good "smell".

But if your "raw" methods are working, I wouldn't bother.

I also wouldn't bother NAV. I would instead consider spending time giving the client an "attitude adjustment".

"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal

We are on the same level Wink | ;)

I try out the Simple Client. I love the smell too.

//ZD

I have a class called Cls_Common.cs which contains a structure called St_Common where I declare the global variables that are common to all .cs files. I use it in Functions, compiled classes .dlls and in Mains.

I create a compiled .dll class to encrypt using these functions and the global structure of Cls_Common.cs.

When i add by reference the compiled class .dll to a Main, in the compile it generates in Visual Studio, there are actually two versions of the file Cls_Common.cs. When doing =new of the global structure, an ambiguity error occurs but execution continues and when an attempt to assign or retrieve a global structure value, occurs an error exception.

Issue:
In order to compile the Cls_Encrypt.dll class I need to include Cls_Common.cs to use common functions. At Main that includes by reference Cls_Encrypt.dll I also need to include Cls_Common.cs and that produces ambiguity.

According to Microsoft's brief solution to error CS0433, you have to compile from the command line with /reference and use an alias:
: https://msdn.microsoft.com/es-es/library/64wh5743.aspx
// compile with: /reference:cs0433_1.dll /reference:TypeBindConflicts=cs0433_2.dll

C#

using TypeBindConflicts;  
public class Test   
{  
   public static void Main()   
   {  
      AggPubImpAggPubImp n6 = new AggPubImpAggPubImp();  
   }  
}

My Program:
==========

Cls_Common.cs:
----------------

C#

namespace Name_Common
{
    public struct St_Common
    {   
       public string Languaje;
    }

    public static partial class Cls_Common
    {   // I define the structure so that there is no error in compiling.
        public static Name_Common.St_Common StCommon;
    }
}

Class compiled in an assembly called Cls_Encrypt.dll This class uses in Mains adding it as reference. Used to encrypt. Inside the class, calls are made to functions such as Func1.cs, Func2.cs ... That use the global variable structure Name_Common.Cls_Common.StCommon

Cls_Encrypt.cs:

C#

---------------
public class Cls_Encrypt
{
    public Cls_Encrypt()  // Constructor.
    {  // Example line:
       if (Name_Common.Cls_Common.StCommon.Languaje == "Eng") ... 
    }
}

Main where I added as reference to compiled class Cls_Encrypt.dll

Main.cs
-----------

C#

namespace Name_Main
{
    public Cls_Main() 
    {
       // At this line, no error event occurs. But if in the debugger I query by Name_Common.Cls_Common.StCommon, it appears:
       // Name_Common.Cls_Common.StCommon error CS0433: type 'Cls_Common' exists in 'Cls_Encrypt, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' and in 'Main, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'

       Name_Common.Cls_Common.StCommon = new Name_Common.St_Common();

       // The execution continues, but in the line:
       string MyVar = Name_Common.Cls_Common.StCommon.Languaje;

       // The exception occurs:
       // + ErrorExcp {"Object reference not set to an instance of an object."} System.Exception {System.NullReferenceException} HResult -2147467261
    }
}

The solution of Microsoft does not serve me because I have to leave Visual Studio to compile from the command line every time I make a change and the solution serves in the main but the functions do not refer to the alias. The solution seems like a fix.

It does not help me to pass by reference the global structure from the main to .dll because to compile the .dll I need to reference the type of the global structure of Cls_Common.cs. In addition, I would need to go through many structures because the .cs functions
are many and require new and different variables. Need global structures, not references.

I ask this:
1.- How can I use a single copy of a global structure in a compiled class .dll and in a main.
2.- When I use the Visual Studio debugger, if the form is large I can not see the code below. How to hide the form?
3.- I have read that I can stop the execution in the debugger (F9) and that I can press Interrupt, Modify a line and Continue. But he will not let me interrupt. How is made? Because now I have to stop the execution and start again.

I do not understand how this problem occurred when it is logical to use a global structure in Main, Functions and .dlls

Thank you.

modified 4-Jan-17 12:56pm.

Including the same file in different parts of the application will always cause this. Your main program should only use the common methods from the DLL, not include the entire file.

55/5000
if I use two dlls? Again I have the same problem. Think of a programmer or business who sells dlls (my case) and sells more than one to the same client.

in this case, from Main I can reference the global space of the first dll (not a good solution), but from the second dll I can not. I do not know how to refer from dlls to a common global space from Main, because I can not do without the global variables since many functions use them constantly. Seriously c# does not have a global space and Microsoft closes the topic with a brief patch That does not solve this problem? Can not be.

modified 4-Jan-17 12:24pm.

The only solution to this issue is to remove the duplicated code from your application. You may even need to rethink your design.

I'm wondering if I can compile the two dlls with the reference to Cls_Common.cs and from main do something like (if possible):
Name_Common.Cls_Common.StCommon = new global::Name_Common.St_Common();

And when I have to call the dlls do something like:
Name_Encrypt.Cls_Encrypt.StCommon = (Name_Common.St_Common)Name_Common.Cls_Common.StCommon

Help, thank you.