Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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!!


1 Answers

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);
like image 155
rnofenko Avatar answered Sep 17 '25 04:09

rnofenko