我正在使用C#(MongDB驱动程序)动态创建集合。 我发现只有在插入至少一个文档后,集合才会被创建。我按照以下方式操作。由于每次插入都调用CreatOne来创建索引,那么每次插入新文档时它会重新创建索引吗? 是否有更好的方法来动态创建集合和索引?
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);
}