UpdateOneAsync不支持表达式树 [英] Expression tree is not supported on UpdateOneAsync

问题描述

在使用此包装器调用UpdateOneAsync时:

On calling UpdateOneAsync, with this wrapper:

    public async Task<UpdateResult> UpdateDocument<T>(
        string sCollectionName, 
        Expression<Func<T, bool>> filter, 
        UpdateDefinition<T> update,
        bool bUpsert,
        System.Threading.CancellationToken cancellationToken
        )
    {
        IMongoDatabase db = _mongoClient.GetDatabase(_optionsMonitor.CurrentValue.databasename);

        IMongoCollection<T> collection = db.GetCollection<T>(sCollectionName);

        return await collection.UpdateOneAsync<T>(filter, update, new UpdateOptions() { IsUpsert = bUpsert }, cancellationToken);
    }

像这样:

private async Task<Models.Errors> UpdateDbOnSyncServerToBoardUpdate(
        CancellationToken cancel,
        MongoDB.Bson.BsonDocument bsonDocConfigurationToUpdate,
        DateTime dtUpdated,
        string sId,
        int iObjectId,
        string sAppName,
        string sModelName
        )
    {
        MongoDB.Driver.UpdateResult updateResult = null;
        Models.Errors errors = null;

        try
        {
            updateResult = await _db.UpdateDocument<Models.Database.NodeBoardModel>(
                Constants.NodeBoardCollectionName,
                node => node.Id == sId && 
                node.RemoteBoard.apps.SingleOrDefault(
                    app => app.appname == sAppName).objects.
                    SingleOrDefault(model => model.name == sModelName).config_docs.
                    Any(config => config.config_id == iObjectId),
                MongoDB.Driver.Builders<Models.Database.NodeBoardModel>.Update.
                Set(
                    node => node.RemoteBoard.apps[-1].objects[-1].config_docs[-1].config_doc, bsonDocConfigurationToUpdate).
                Set(
                    node => node.RemoteBoard.apps[-1].objects[-1].config_docs[-1].config_dt, dtUpdated),
                false,
                cancel
                );

我收到NotSupportedException:

I receive a NotSupportedException:

不支持表达式树:{document} {RemoteBoard} {apps} .SingleOrDefault(app =>(app.appname =="eACM")).objects.SingleOrDefault(model =>(model.name == 标签")).config_docs

The expression tree is not supported: {document}{RemoteBoard}{apps}.SingleOrDefault(app => (app.appname == "eACM")).objects.SingleOrDefault(model => (model.name == "tag")).config_docs

我感觉我以错误的方式或MongoDb不支持的方式使用LINQ关键字，但是很难准确说明问题出在哪里.

I sense I am using a LINQ keyword the wrong way or in a way that's not supported by MongoDb but it's hard to tell exactly where the problem lies.

我无法对堆栈进行任何跟踪:

I can't make anything of the stack trace:

在MongoDB.Driver.Linq.Processors.EmbeddedPipeline.EmbeddedPipelineBinder.BindNonMethodCall(Expression节点)上的

在MongoDB.Driver.Linq.Processors.PipelineBinderBase 1.BindPipeline(Expression node) at MongoDB.Driver.Linq.Processors.PipelineBinderBase 1.BindMethodCall(MethodCallExpression节点) 在MongoDB.Driver.Linq.Processors.EmbeddedPipeline.EmbeddedPipelineBinder.Bind(表达式节点，IBindingContext父级) 在MongoDB.Driver.Linq.Processors.SerializationBinder.VisitMethodCall(MethodCallExpression节点) 在System.Linq.Expressions.MethodCallExpression.Accept(ExpressionVisitor访问者) 在MongoDB.Driver.Linq.Processors.SerializationBinder.Visit(Expression节点)上 在System.Linq.Expressions.ExpressionVisitor.VisitBinary(BinaryExpression节点) 在MongoDB.Driver.Linq.Processors.SerializationBinder.VisitBinary(BinaryExpression节点)上 在System.Linq.Expressions.BinaryExpression.Accept(ExpressionVisitor访问者) 在MongoDB.Driver.Linq.Processors.SerializationBinder.Visit(表达式节点)上 在MongoDB.Driver.Linq.Translators.PredicateTranslator.Translate [TDocument](Expression 1 predicate, IBsonSerializer 1 parameterSerializer，IBsonSerializerRegistry serializerRegistry)处 在MongoDB.Driver.MongoCollectionImpl 1.ConvertWriteModelToWriteRequest(WriteModel 1模型上，Int32索引) 在System.Linq.Enumerable.SelectIterator [TSource，TResult](IEnumerable 1 source, Func 3选择器)+ MoveNext() 在System.Collections.Generic.List 1.AddEnumerable(IEnumerable 1上可枚举) 在System.Linq.Enumerable.ToList [TSource]处(IEnumerable 1 source) at MongoDB.Driver.Core.Operations.BulkMixedWriteOperation..ctor(CollectionNamespace collectionNamespace, IEnumerable 1请求，MessageEncoderSettings messageEncoderSettings) 在MongoDB.Driver.MongoCollectionImpl 1.CreateBulkWriteOperation(IEnumerable 1请求上，BulkWriteOptions选项) 在MongoDB.Driver.MongoCollectionImpl 1.BulkWriteAsync(IClientSessionHandle session, IEnumerable 1请求时，BulkWriteOptions选项，CancellationToken cancelledToken) 在MongoDB.Driver.MongoCollectionImpl 1.UsingImplicitSessionAsync[TResult](Func 2 funcAsync，CancellationToken cancelToken上) 在MongoDB.Driver.MongoCollectionBase 1.UpdateOneAsync(FilterDefinition 1过滤器上，UpdateDefinition 1 update, UpdateOptions options, Func 3 bulkWriteAsync) 在C:\ GIT \ app-manager \ APIMM \ ServerLevelConfiguration \ WebApplication \ Services \ ConcreteDatabase.cs中的WebApplication.Services.ConcreteDatabase.UpdateDocument [T](字符串sCollectionName，Expression 1 filter, UpdateDefinition 1更新，布尔bUpsert，CancellationToken cancelleToken)上: 131行 在C:\ GIT \ app-manager \ APIMM \ ServiceBackground \ Web \ Application.Services.SyncBoardDatabaseBackgroundService.UpdateDbOnSyncServerToBoardUpdate(CancellationToken cancel，BsonDocument bsonDocConfigurationToUpdate，DateTime dtUpdated，String sId，Int32 iObjectId，String sAppName，String sModelName)中. cs:353行

at MongoDB.Driver.Linq.Processors.EmbeddedPipeline.EmbeddedPipelineBinder.BindNonMethodCall(Expression node) at MongoDB.Driver.Linq.Processors.PipelineBinderBase1.BindPipeline(Expression node) at MongoDB.Driver.Linq.Processors.PipelineBinderBase1.BindMethodCall(MethodCallExpression node) at MongoDB.Driver.Linq.Processors.EmbeddedPipeline.EmbeddedPipelineBinder.Bind(Expression node, IBindingContext parent) at MongoDB.Driver.Linq.Processors.SerializationBinder.VisitMethodCall(MethodCallExpression node) at System.Linq.Expressions.MethodCallExpression.Accept(ExpressionVisitor visitor) at MongoDB.Driver.Linq.Processors.SerializationBinder.Visit(Expression node) at System.Linq.Expressions.ExpressionVisitor.VisitBinary(BinaryExpression node) at MongoDB.Driver.Linq.Processors.SerializationBinder.VisitBinary(BinaryExpression node) at System.Linq.Expressions.BinaryExpression.Accept(ExpressionVisitor visitor) at MongoDB.Driver.Linq.Processors.SerializationBinder.Visit(Expression node) at MongoDB.Driver.Linq.Translators.PredicateTranslator.Translate[TDocument](Expression1 predicate, IBsonSerializer1 parameterSerializer, IBsonSerializerRegistry serializerRegistry) at MongoDB.Driver.MongoCollectionImpl1.ConvertWriteModelToWriteRequest(WriteModel1 model, Int32 index) at System.Linq.Enumerable.SelectIterator[TSource,TResult](IEnumerable1 source, Func3 selector)+MoveNext() at System.Collections.Generic.List1.AddEnumerable(IEnumerable1 enumerable) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at MongoDB.Driver.Core.Operations.BulkMixedWriteOperation..ctor(CollectionNamespace collectionNamespace, IEnumerable1 requests, MessageEncoderSettings messageEncoderSettings) at MongoDB.Driver.MongoCollectionImpl1.CreateBulkWriteOperation(IEnumerable1 requests, BulkWriteOptions options) at MongoDB.Driver.MongoCollectionImpl1.BulkWriteAsync(IClientSessionHandle session, IEnumerable1 requests, BulkWriteOptions options, CancellationToken cancellationToken) at MongoDB.Driver.MongoCollectionImpl1.UsingImplicitSessionAsync[TResult](Func2 funcAsync, CancellationToken cancellationToken) at MongoDB.Driver.MongoCollectionBase1.UpdateOneAsync(FilterDefinition1 filter, UpdateDefinition1 update, UpdateOptions options, Func3 bulkWriteAsync) at WebApplication.Services.ConcreteDatabase.UpdateDocument[T](String sCollectionName, Expression1 filter, UpdateDefinition1 update, Boolean bUpsert, CancellationToken cancellationToken) in C:\GIT\app-manager\APIMM\ServerLevelConfiguration\WebApplication\Services\ConcreteDatabase.cs:line 131 at WebApplication.Services.SyncBoardDatabaseBackgroundService.UpdateDbOnSyncServerToBoardUpdate(CancellationToken cancel, BsonDocument bsonDocConfigurationToUpdate, DateTime dtUpdated, String sId, Int32 iObjectId, String sAppName, String sModelName) in C:\GIT\app-manager\APIMM\ServerLevelConfiguration\WebApplication\Services\SyncBoardDatabaseBackgroundService.cs:line 353

模型类:

public class NodeBoardModel
{
    [BsonId]
    [BsonRepresentation(BsonType.ObjectId)]
    public string Id { get; set; }

    [BsonElement]
    public NodeBoardRemoteModel RemoteBoard { get; set; }
}

public class NodeBoardRemoteModel
{
    [BsonElement]
    public List<NodeBoardAppModel> apps { get; set; }
}

public class NodeBoardAppModel
{
    [BsonElement]
    public string appname { get; set; }

    [BsonElement]
    public List<NodeBoardObjectModel> objects { get; set; }
}

public class NodeBoardObjectModel
{
    [BsonElement]
    public string name { get; set; }

    [BsonElement]
    public List<NodeBoardObjectConfigurationModel> config_docs { get; set; }
}

public class NodeBoardObjectConfigurationModel
{
    [BsonElement]
    public BsonDocument config_doc { get; set; }

    [BsonElement]
    public DateTime config_dt { get; set; }

    [BsonElement]
    public int config_id { get; set; }
}

推荐答案

当您尝试构建Update语句时，问题就开始了.您可能知道-1作为索引传递的将是 $位置运算符 一个>. 文档表示

The problem starts when you're trying to build your Update statement. As you probably know -1 passed as an index will be translated to the $ positional operator. The documentation says that

位置$运算符不能用于遍历一个以上数组的查询，例如遍历嵌套在其他数组中的数组的查询，因为$占位符的替换是单个值

The positional $ operator cannot be used for queries which traverse more than one array, such as queries that traverse arrays nested within other arrays, because the replacement for the $ placeholder is a single value

此外，您尝试使用SingleOrDefault建立过滤条件，并且.NET MongoDB驱动程序无法将其转换为任何MongoDB查询语法运算符.

Additionally you're trying to build your filtering condition using SingleOrDefault and .NET MongoDB driver is not able to translate that into any MongoDB query syntax operator.

该如何解决?

您可以尝试使用位置过滤的运算符语法.

var filter = Builders<NodeBoardModel>.Filter.Eq(f => f.Id, sId);
var update = Builders<NodeBoardModel>.Update.Set("RemoteBoard.apps.$[app].objects.$[object].config_docs.$[configdoc].config_dt", dtUpdated);

var arrayFilters = new List<ArrayFilterDefinition>();
ArrayFilterDefinition<BsonDocument> appFilter = new BsonDocument("app.appname", new BsonDocument("$eq", sAppName));
ArrayFilterDefinition<BsonDocument> objectFilter = new BsonDocument("object.name", new BsonDocument("$eq", sModelName));
ArrayFilterDefinition<BsonDocument> configDocFilter = new BsonDocument("configdoc.config_id", new BsonDocument("$eq", iObjectId));

arrayFilters.AddRange(new[] { appFilter, objectFilter, configDocFilter });

var updateOptions = new UpdateOptions { ArrayFilters = arrayFilters };

var res = Col.UpdateOne(filter, update, updateOptions);

这篇关于UpdateOneAsync不支持表达式树的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！