public List <Product> GetAllProducts() { var query = ProductsList.Find(new BsonDocument()).ToListAsync(); return(query.Result); // var query = (from a in ProductsList.AsQueryable<Product>().Select() select a).Join(from b in CategoriesList.AsQueryable<Category>() select b); }