MongoDb C# Creating Index and Collection dynamiaclly

Question

I am creating a collection dynamically using C#(MongDB driver). I found that collection gets created only if atleast one document is inserted into it. i am doing as below. Since i am calling CreatOne for every insert to create index, will it ReCreate index every time i insert new docs? Is there any better way for creating collection and index dynamically than this?

public static void CreatAndInsert(double value1, double value2, string collectoinName)
    {
        var connectionString = "mongodb://localhost";
        var client = new MongoClient(connectionString);
        var database = client.GetDatabase("sample");

        //Create Index
        var indexDefn = Builders<BsonDocument>.IndexKeys.Ascending("datetime");
        string collectionName = collectoinName;
        database.GetCollection<BsonDocument>(collectionName).Indexes.CreateOne(indexDefn, new CreateIndexOptions() { Background = true, Sparse = true});

        //Create Collection
        var dbcollection = database.GetCollection<BsonDocument>(collectionName);

        var document = new BsonDocument
                {
                    { "_id", ObjectId.GenerateNewId()},
                    { "Key1", value1 },
                    { "Key2", value2},
                    { "datetime", DateTime.Now }
                };

        dbcollection.InsertOne(document);
    }

Jehof · Accepted Answer · 2018-03-06 11:53:40Z

3

You could check first if the index exists, before creating it. The API provides a method IndexExistsByName to check if an index exists or not.

var collection = database.GetCollection<BsonDocument>(collectionName);

if (! collection.IndexExistsByName("myindex")) {
  collection.Indexes.CreateOne(indexDefn, new CreateIndexOptions() { Background = true, Sparse = true});
}

answered Mar 6, 2018 at 11:53

Jehof

35.7k11 gold badges129 silver badges156 bronze badges

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

2 Comments

Vaibhav shetty Over a year ago

will it ReCreate index every time i insert new docs with CreateOne calling on database?

Markus Over a year ago

IndexExistsByName seems to not exist with latest .net Mongo.db Driver 2.9.2. According to stackoverflow.com/questions/35019313/… it's idempotent so not necessary to check for index already existing.

shehryar · Accepted Answer · 2021-11-16 12:05:18Z

0

At the Moment of November 2021, Your Code works perfectly fine even when you don't insert a value. I'm using MongoDB.Driver at Version 2.13.2.

public static void CreateCollection(string collectoinName)
    {
        var connectionString = "mongodb://SERVER_ADDRESS:PORT";
        var client = new MongoClient(connectionString);
        var database = client.GetDatabase("test");

        //Create Index
        var indexDefn = Builders<BsonDocument>.IndexKeys.Ascending("datetime");
        string collectionName = collectoinName;
        database.GetCollection<BsonDocument>(collectionName).Indexes.CreateOne(indexDefn, new CreateIndexOptions() { Background = true, Sparse = true });

        
    }

answered Nov 16, 2021 at 12:05

shehryar

1181 silver badge8 bronze badges

Collectives™ on Stack Overflow

MongoDb C# Creating Index and Collection dynamiaclly

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related