Weird $select behavior

[vc-74]

Following this sample I have created a dynamic OData service. The model starts empty and grows as requests are executed. The model is updated during MatcherPolicy.ApplyAsync, and the route values are updated accordingly.

I have been able to use all the OData features (Select, Filter, OrderBy, Count, SkipToken, SetMaxTop) without any issues but certain requests with a filter 'break' the service, and following requests with a filter randomly error with a 500 status code although they worked previously.

The stack trace when that happens is the following:

System.Runtime.Serialization.SerializationException: 'EnumerableQuery`1' cannot be serialized using the OData output formatter.
 at Microsoft.AspNetCore.OData.Formatter.ODataOutputFormatterHelper.GetSerializer(Type type, Object value, HttpRequest request, IODataSerializerProvider serializerProvider)
 at Microsoft.AspNetCore.OData.Formatter.ODataOutputFormatterHelper.WriteToStreamAsync(Type type, Object value, IEdmModel model, ODataVersion version, Uri baseAddress, MediaTypeHeaderValue contentType, HttpRequest request, IHeaderDictionary requestHeaders, IODataSerializerProvider serializerProvider)
 at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResultFilterAsync>g__Awaited|30_0[TFilter,TFilterAsync](ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
 at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResultExecutedContextSealed context)
 at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.ResultNext[TFilter,TFilterAsync](State& next, Scope& scope, Object& state, Boolean& isCompleted)
 at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeResultFilters()

Can a dynamic model prevent filtering from working properly?

[vc-74]

To add more context, below is a typical sequence reproducing the issue:

• http://service/EntitySet1?$select=ID,Name works
• http://service/EntitySet1?$select=ID,Name works again
• http://service/EntitySet2?$select=ID,Name works too
• http://service/EntitySet1?$select=ID,Name no longer works with this message:
  500 Internal Server Error.
  System.Runtime.Serialization.SerializationException
  'EnumerableQuery`1' cannot be serialized using the OData output formatter.

[rbalagangadharan]

@vc-74
I am also working on Dynamic Entity without EF. How you are converting the OData to SQL query. Here the below post of the Thread in Q&A section.

#1200