代码之家  ›  专栏  ›  技术社区  ›  cpiock

带有MongoDB API的CosmosDB

  •  0
  • cpiock  · 技术社区  · 7 年前

    MongoClientSettings settings = MongoClientSettings.FromUrl(
                          new MongoUrl(connectionString)
                        );
                        settings.SslSettings =
                          new SslSettings() { EnabledSslProtocols = SslProtocols.Tls12 };    
        var mongoClient = new MongoClient(settings);
        var mongoDatabase = mongoClient.GetDatabase("MYDATABASE");
        var mongoCollection = mongoDatabase.GetCollection<BsonDocument>("MYCOLLECTION");
    
        var builder = Builders<BsonDocument>.Filter;            
        var filter = builder.Lt("mac", "001BC50670101BB8") & builder.Gte("date", "2016-09-18T00:00:00Z") & builder.Gte("date", "2017-09-22T00:00:00Z");
    
        var query = mongoCollection.Find<BsonDocument>(filter).ToList<BsonDocument>();
    

    但当它在服务器上运行查询时,我得到了以下错误:

    Errors":["An invalid query has been specified with filters against path(s) that are not range-indexed. Consider adding allow scan header in the request."
    

    我发现应该在请求中添加“x-ms-documentdb-query-enable-scan”标题。但是我怎么能做到呢?

    1 回复  |  直到 6 年前
        1
  •  2
  •   marc_s    7 年前

    builder.Lt("mac", "001BC50670101BB8")
    

    builder.Eq("mac", "001BC50670101BB8")