use of "in" in mongodb

Question

I am using mongodb in vb.net

I need to send more than one resource_id similar to "in" in sql.

please help.

My Codes are:

Dim ConnString as String=ConfigurationManager.AppSettings("ConnStringMongo")
Dim server As MongoServer=MongoServer.Create(Connstring)
Dim ceilometer As MongoDatabase=server.GetDatabase("ceilometer")

Dim query=New QueryDocument()
query.Add("user_id","Jewel")

'' Is it possible? or how can i achieve this

 query.Add("resource_id","in('100','200')") 



Dim Docs=ceilometer.GetCollection("meter").Find(query)

Answer 1

You could do something like:

Dim resource_ids = New BsonValue() {"100", "200"}
Dim query = Query.And(
    Query.EQ("user_id", "Jewel"),
    Query.In("resource_id", resource_ids)
)

Dim Docs = ceilometer.GetCollection("meter").Find(query)