Getting a collection of objects

Question

I cannot figure out how to make the Read function on mongoDB in asp.net mvc 5. I have this piece of code in the controller:

 public HomeController() {
           var mongoClient = new MongoClient(Settings.Default.EmployeesConnectionString);
           var database= mongoClient.GetDatabase("football");
           var coll = database.GetCollection<BsonDocument>("Footballers");

As you can see, I have database paths and collections stored in variables, so it would be easier to navigate. I also checked this, I managed to create a new collection in mongodb, so I guess this is correct. My question is, what should I write next in order to return the whole collection? Should it be on the List? After that, I will try to return it to the web page, so if you have any comments about this, please let me know.

Answer 1

I managed to figure it out.

var coll = database.GetCollection<BsonDocument>("Footballers");

        var documents = coll.Find(new BsonDocument()).ToList();
        for(int i=0; i<documents.Count(); i++){
            Console.WriteLine(documents[i]);
        }
        Console.ReadLine();

document , .

Answer 2

2.x API Async. API 1.x, , , .

3 : ToListAsync()

var list = await col.Find(new BsonDocument()).ToListAsync();
foreach (var doc in list)
{
    Console.WriteLine (doc.ToJson());
}

ForEachAsync()

await col.Find(new BsonDocument())
    .ForEachAsync((doc,i) => { 
      Console.WriteLine ("Doc #{0}:{1}",i,doc);
    });

ToCursorAsync()

using (var cursor = await col.Find(new BsonDocument()).ToCursorAsync())
{
 while (await cursor.MoveNextAsync())
 {
  foreach (var doc in cursor.Current)
  {
    Console.WriteLine (doc.ToJson());
  }
 }
}

ToCursorAsync , , , -. , , .

Answer 3

GenericRecord,

IEnumerable globalRelordList = MongoClient.GetDatabase( "" );

:

char[] commaSeperated = new char[] { ',' };
string[] auditRecordJSON = G.Data.Split(commaSeperated, 2);
auditRecordDTO audit = (jsonParser.JsonDeserialize<AuditRecord>("{" +auditRecordJSON[1]));

GenericRecord :

public class GenericRecord{}
{   public string Id { get; set; }
    public string Data { get; set; }
    public string CollectionName { get; set; }
    public RecordFormat Format { get; set; }
}

auditRecordDTO - # DTO, JSON, DTO.