I need IQueryable extension method for my custom query. Example method and I want be result is below. How can I do this ?

Input =>

.Where(x => x.Id == 1)
.FilterContent<ProductTranslate>(x => x.ProductName == "product1" 
                                      && x.ShortDescription.Contains("short desc") 
                                      || x.Description.Contains("desc"), 1)

Output=>

x => (x.Key == "ProductName" && x.Value=="product1")
     && (x.Key == "ShortDescription" && x.Value.Contains("short desc") 
         || (x.Key == "Description" && x.Value.Contains("desc")))

Regards.

CodePudding user response：

My roughly database scheme is below. I have a TranslateRecords and TranslateResource tables for covers all entities multilanguage content.i put the translateId column with multiple language options entity table. so I can use all my content in one table without opening a separate translate table for each entity.

I just want to make an extension method because very complex queries occur in the filters I mentioned in the topic.

I will take your suggestions into consideration. thank you.

CodePudding user response：

I think I understand what you are asking, but I will say the solution is way beyond me.

It sounds like to me that you need a function that parses an expression tree of type Func<Product, bool> (or more generally Func<T, TResult>) and convert it into an expression tree of type Func<ProductTranslate, bool> (or more generally Func<T2, TResult>).

The article https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/concepts/expression-trees/how-to-modify-expression-trees may be a start. The translation function would walk the original tree and build up a new modified tree. Luckily, it looks like ExpressionVisitor base class can do most of the work. You would need check each node to see if it is a T.Property reference and replace it with the appropriate T2.Property, T2["Property"], T2.GetPropertyValueByName("Property") or similar. You may also have to identify and replace whatever node accepts this T and an input parameter and replace it with a this T2 equivalent. Tracking the Product ID and language ID may involve additional changes.

As to how to detect and interpret the T.Property node, that may take some digging on your part, but I expect there must be some tools out there to dump expression trees in human readable forms that could help. Perhaps you can dump an original expression tree and a hand-coded objective expression tree to examine the differences.

If you get through all that, applying the new function to the IQueryable<>.Where() function should be the easy part.

P.S., Out of interest, is the following roughly the database structure you are working with, where your ProductTranslateKey class is your in-memory on-demand loaded representation of LanguageTranslate?

Products:

Languages:

LanguageTranslate: