Querying UUID fields in Mongodb using C#

Question

I have some GUIDs stored in my collection in MongoDb. The problem is that I cannot query for them using simple

Query.EQ("GuidField", Guid)

They are stored OK but I cannot search for them. How should I query then?

Are you storing the GUIDs in a string or binary field?

Chris Fulstow
– Chris Fulstow

2011-09-05 13:04:37 +00:00
Commented Sep 5, 2011 at 13:04 — Chris Fulstow
– Chris Fulstow, Commented Sep 5, 2011 at 13:04

Andrew Orsich · Accepted Answer · 2011-09-05 13:06:20Z

2

Hmm, try to debug following example to see that it is works:

var _mongoServer = MongoServer.Create(
     MongoUrl.Create("mongodb://admin(admin):1@orsich-pc:27020"));

var database = _mongoServer.GetDatabase("StackoverflowExamples");
var collection = database.GetCollection("guids");

var guid = Guid.NewGuid();
var item = new Item()
   {
     Id = ObjectId.GenerateNewId().ToString(),
     GuidField = guid
   };

collection.Insert(item);

var itemFromDb = collection.FindOneAs<Item>(Query.EQ("GuidField", guid));

Item class:

public class Item
{
  [BsonId]
  public string Id { get; set; }
  public Guid GuidField { get; set; }
}

answered Sep 5, 2011 at 13:06

Andrew Orsich

53.8k17 gold badges142 silver badges134 bronze badges

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

Collectives™ on Stack Overflow

Querying UUID fields in Mongodb using C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related