Building indexes in MongoDB with .NET driver 2.0

Question

What's the new way to build indexes with the new driver 2.0? There's no documentation whatsoever about this.

Apparently this now works with the new IndexKeysDefinitionBuilder<> interface but that's all I got so far.

I'm having the same problem after upgrading to 2.0! Why did they feel the need to absolute overcomplicate something that was simple!? — John Doherty
– John Doherty, Commented May 6, 2015 at 14:12
I am starting to like it. I can see where the design decisions came from and the usage of builders in this case is consistent with other usages (filter builders, etc). I especially like that they have made everything fully async. It's just (currently at least) not well documented and not easy to get detailed information or samples. — hholtij
– hholtij, Commented May 7, 2015 at 12:54
It's been a couple of days and I'm liking it too, especially the async stuff. It was so many changes with very little documentation that frustrated me, I had to resort to reading the source on github... I'm sure they'll resolve that soon though — John Doherty
– John Doherty, Commented May 8, 2015 at 23:52

i3arnon · Accepted Answer · 2015-06-25 15:46:52Z

19

You need to call and await CreateOneAsync with an IndexKeysDefinition you get by using Builders.IndexKeys:

static async Task CreateIndex()
{
    var client = new MongoClient();
    var database = client.GetDatabase("db");
    var collection = database.GetCollection<Hamster>("collection");
    await collection.Indexes.CreateOneAsync(Builders<Hamster>.IndexKeys.Ascending(_ => _.Name));
}

If you don't have a Hamster you can also create the index in a non-strongly-typed way by specifying the index's json representation:

await collection.Indexes.CreateOneAsync("{ Name: 1 }");

edited Jun 25, 2015 at 15:46

answered Apr 8, 2015 at 1:45

i3arnon

117k33 gold badges334 silver badges358 bronze badges

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

3 Comments

BigJoe714 Over a year ago

Thanks. Do you know how to do it for BsonDocument collections?

i3arnon Over a year ago

@BigJoe714 I've updated the post. Does that answer your question?

Sri Chatala Over a year ago

How to create multiple indexes by using Indexes.CreateMany()?

Collectives™ on Stack Overflow

Building indexes in MongoDB with .NET driver 2.0

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related