Search code examples
c#mongodbmongodb-.net-drivermongodb-csharp-2.0

mongodb c# select specific field


Need some help creating a generic method for selecting fields by their name.

something like this:

T GetDocField<T>(string doc_Id, string fieldName)

The best I got is using projection which gives me the doc with only the wanted field seted:

 public T GetDocField<T>(string Doc_Id, string fieldName)
 {
    var value = DocCollection.Find(d => d.Id == Doc_Id)
               .Project<T>(Builders<Doc>.Projection
               .Include(new StringFieldDefinition<Doc>
               (fieldName))).FirstOrDefaultAsync().Result;

note: I'm using the new c# driver (2.0)

Thanks!!


Solution

  • You can do next:

    public async Task<TValue> GetFieldValue<TEntity, TValue>(string id, Expression<Func<TEntity, TValue>> fieldExpression) where TEntity : IEntity
    {
        var propertyValue = await collection
            .Find(d => d.Id == id)
            .Project(new ProjectionDefinitionBuilder<TEntity>().Expression(fieldExpression))
            .FirstOrDefaultAsync();
    
        return propertyValue;
    }
    

    and call it

    var value = await GetFieldValue<Item, string>("111", x => x.Name);