Description
Trying to integrate Microsoft OData v4 stack with Mongo C# Driver. I would like to expose a Mongo collection and enable the OData $filter operation against the fields contained in the ExtraElements dictionary.
I have created a minimal example of the issue. Beginning with an empty WebAPI project in Visual Studio 2015, I created the following model:
public class TestEntity
{ [BsonId, BsonElement("_id")] public ObjectId _id \{ get; set; }public string Id { get; set; }
[BsonExtraElements]
public Dictionary<string, object> ExtraElements { get; set; }
}
I exposed EDM EntitySet via OData by adding the following at the end of `WebApiConfig.Register()` method:
// OData
var edmBuilder = new ODataConventionModelBuilder();
edmBuilder.EntitySet<TestEntity>("test");
config.MapODataServiceRoute("odata", "odata", edmBuilder.GetEdmModel());
Finally, I created a simple TestController:
public class TestController : ODataController
{
[EnableQuery(AllowedFunctions = Microsoft.AspNet.OData.Query.AllowedFunctions.All)]
public IQueryable<TestEntity> Get()
}
I added an actual object to the Mongo collection:
> db.test.insert( {Id:'test', Name:'testName'}) WriteResult({ "nInserted" : 1 })
> db.test.find()
> { "_id" : ObjectId("5c266040fd7e5a3c63b33cd8"), "Id" : "test", "Name" : "testName" }
Now I can query find as long as I don't try to use $filter on the ExtraElements (note that OData is not rendering the ObjectId field properly, but I do not believe this is related to the problem):
http://localhost:63927/odata/test
{"@odata.context":"http://localhost:63927/odata/$metadata#test","value":[\{"Id":"test","Name":"testName","_id":{}}]}
However, if I try to filter against the `Name` (one of the `ExtraElements`) the following error occurs:
http://localhost:63927/odata/test?$filter=Name%20eq%20%27testName%27
*Message: Convert(IIF((({document}
{ExtraElements} != null) AndAlso {document}{ExtraElements}.ContainsKey(\"Name\")), {document}
{ExtraElements}.Item[\"Name\"], null)) is not supported.*
Exception: System.InvalidOperationException
Stack Trace:
at MongoDB.Driver.Linq.Translators.PredicateTranslator.GetFieldExpression(Expression expression)
at MongoDB.Driver.Linq.Translators.PredicateTranslator.TranslateComparison(Expression variableExpression, ExpressionType operatorType, ConstantExpression constantExpression)
at MongoDB.Driver.Linq.Translators.PredicateTranslator.Translate(Expression node)
at MongoDB.Driver.Linq.Translators.PredicateTranslator.Translate(Expression node, IBsonSerializerRegistry serializerRegistry)
at MongoDB.Driver.Linq.Translators.QueryableTranslator.TranslateWhere(WhereExpression node)
at MongoDB.Driver.Linq.Translators.QueryableTranslator.TranslatePipeline(PipelineExpression node)
at MongoDB.Driver.Linq.Translators.QueryableTranslator.Translate(Expression node, IBsonSerializerRegistry serializerRegistry, ExpressionTranslationOptions translationOptions)
at MongoDB.Driver.Linq.MongoQueryProviderImpl`1.Execute(Expression expression)
at MongoDB.Driver.Linq.MongoQueryableImpl`2.GetEnumerator()
at Microsoft.AspNet.OData.Formatter.Serialization.ODataResourceSetSerializer.WriteResourceSet(IEnumerable enumerable, IEdmTypeReference resourceSetType, ODataWriter writer, ODataSerializerContext writeContext)
at Microsoft.AspNet.OData.Formatter.ODataOutputFormatterHelper.WriteToStream(Type type, Object value, IEdmModel model, ODataVersion version, Uri baseAddress, MediaTypeHeaderValue contentType, IWebApiUrlHelper internaUrlHelper, IWebApiRequestMessage internalRequest, IWebApiHeaders internalRequestHeaders, Func`2 getODataMessageWrapper, Func`2 getEdmTypeSerializer, Func`2 getODataPayloadSerializer, Func`1 getODataSerializerContext)
at Microsoft.AspNet.OData.Formatter.ODataMediaTypeFormatter.WriteToStreamAsync(Type type, Object value, Stream writeStream, HttpContent content, TransportContext transportContext, CancellationToken cancellationToken)
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.WebHost.HttpControllerHandler.<WriteBufferedResponseContentAsync>d__1b.MoveNext()