Using C# MongoDB to convert Int to String?

Question

I'm using C# MongoDb.Driver(2.10) to get a document from a collection :

MongoClient dbClient = new 
MongoClient("mongodb://***");
IMongoDatabase db = dbClient.GetDatabase("***");
var collection = db.GetCollection<BsonDocument>("***");
Console.WriteLine( collection.Find(Builders<BsonDocument>.Filter.Empty).First());

This does work and emits this :

So everything is OK.

But now I want to try to filter where lockPolicyId.ToString()=="1" .(As a string , not as a number)

So I've tried :

var filter= Builders<BsonDocument>.Filter.Where(a=>a["lockPolicyId"].AsString=="1");
var t=collection.Find( filter ).First() ;
Console.Writeline(t);

Which shows this error :

The operands for operator 'Equal' do not match the parameters of method 'op_Equality'.

I've also tried:

 var filter= Builders<BsonDocument>.Filter.Where(a=>a["lockPolicyId"].ToString()=="1");

And got this error:

{document}{lockPolicyId}.ToString() is not supported.

Now, I do understand why it's happening ( Int and not String).

But still

Question:

How can I filter by the ToString value?

In other words, to make this line works:

Builders<BsonDocument>.Filter.Where(a=>a["lockPolicyId"].AsString=="1")

The column must be another class. When you type the period what options are you given? — jdweng
– jdweng, Commented Jan 19, 2020 at 11:11
It is a MongoDB object. Those selections are not a standard Net Library type. — jdweng
– jdweng, Commented Jan 19, 2020 at 14:53

marc_s · Accepted Answer · 2020-05-26 05:08:09Z

2

Not possible.

MongoDB C# driver interprets a=>a["lockPolicyId"]==1 as {lockPolicyId: {"$eq" : "1"}}.

When you try a=>a["lockPolicyId"].AsString=="1", it can't be interpreted into MongoDB syntax... (such query {{$toString:"lockPolicyId"} : "1"} is invalid)

MongoDB .find method has exception with $where operator:

db.collection.find({"$where": "this.lockPolicyId.toString() == '1'"})

But you need to write such queries manually (can't be written by Predicate interface). Note: It's very slow

MongoDB offers aggregate command to perform unusual queries. You need to define query pipeline. If you use $toString operator in the 1st stage and then apply matching criteria in the 2nd one, it will work:

db.collection.aggregate([
    {$addFields:{
        lockPolicyId : {$toString:"$lockPolicyId"}
    }},
    {$match:{
        lockPolicyId : "1"
    }}
])

edited May 26, 2020 at 5:08

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Jan 19, 2020 at 11:29

Valijon

13.2k4 gold badges40 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Royi Namir Over a year ago

So what is AsString is there for ?

Collectives™ on Stack Overflow

Using C# MongoDB to convert Int to String?

1 Answer 1

Not possible.

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Not possible.

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related