50

I need to retrieve all the documents that are in my collection in MongoDB, but I cannot figure out how. I have declared my 'collection' like this-

private static IMongoCollection<Project> SpeCollection = db.GetCollection<Project>("collection_Project");

And I followed what is explained in this MongoDB tutorial. I adjusted it for my needs, like-

 var documents = await SpeCollection.Find(new Project()).ToListAsync();

However, I keep having the following error-

MongoDB.Driver.IMongoCollection does not have a definition for 'Find' and the best override of the extension method [superlong stuff]. Find contains non valid arguments.

Minhas Kamal
  • 20,752
  • 7
  • 62
  • 64
NicolasR
  • 874
  • 2
  • 11
  • 18

3 Answers3

115

Using the current version of the driver (v2.0) you can do that by passing a filter that matches everything:

var documents = await SpeCollection.Find(_ => true).ToListAsync();

They have also added an empty filter (FilterDefinition.Empty) which will arrive in the next version of the driver (v2.1):

var documents = await SpeCollection.Find(Builders<Project>.Filter.Empty).ToListAsync();
i3arnon
  • 113,022
  • 33
  • 324
  • 344
18

Simplest Way

Retrieve all the documents-

var documents = SpeCollection.AsQueryable();

Also convert to JSON object-

var json = Json(documents, JsonRequestBehavior.AllowGet);
Minhas Kamal
  • 20,752
  • 7
  • 62
  • 64
8

If you want all documents, why not use Find all?

var documents = await SpeCollection.Find(new BsonDocument()).ToListAsync();
S.Spieker
  • 7,005
  • 8
  • 44
  • 50