I would appreciate a lot if someone could guide me whether how I can get all products as a LINQ statement from Merchello.
I mean that I need to get all products as Products Display but without actual a database call because before, I would need to make some filtering.
I don't need the one merchelloHelper.Query.Product.Search(1, int.MaxValue).Items.Select(x => (ProductDisplay)x); because it actually get all products at one go.
I would need all products before actually get all products because of some filtering (get products in certain collections).
Get all Products AS a LINQ statement - Merchello 2.2.0
Hi Guys,
I would appreciate a lot if someone could guide me whether how I can get all products as a LINQ statement from Merchello.
I mean that I need to get all products as Products Display but without actual a database call because before, I would need to make some filtering.
I don't need the one
merchelloHelper.Query.Product.Search(1, int.MaxValue).Items.Select(x => (ProductDisplay)x);
because it actually get all products at one go.I would need all products before actually get all products because of some filtering (get products in certain collections).
I have already tried it out, which is listed here: https://our.umbraco.org/projects/collaboration/merchello/merchello/81717-products-search-by-collection-is-quite-slow-using-version-220 but actually the above code is actually get immediately all products which causing the search to be slow.
Appreciate any help.
Kind Regards
Any feedback guys?
Thanks
Hi Simon,
Have you seen the ProductContentQuery builder - https://our.umbraco.org/projects/collaboration/merchello/merchello/79449-get-list-of-products-from-collections-merchello#comment-256518
Does this work for you?
Hi Rusty,
I am using Merchello 2.2.0.
is working on a reply...