Expression abstraction

Aiguil Leblanc

Is it possible to avoid duplication of this method for each string field in the model I want to check for a match? If MyModel is abstracted then obviously the MyModelField in the lambda expression is not recognized anymore, so I'm thinking maybe some kind of reflection to access the field by name?

private Expression<Func<MyModel, bool>> MatchMyModelFieldByStrategy(SearchItem searchItem)
{
    var searchItemKey = searchItem.Value.ToLower();
    Expression<Func<MyModel, bool>> defaultExp = s => s.MyModelField.ToLower().Contains(searchItemKey);
    switch (searchItem.SearchStrategy)
    {
        case StrStrategy.Contains:
            return defaultExp;
        case StrStrategy.StartsWith:
            return s => s.MyModelField.ToLower().StartsWith(searchItemKey);
        case StrStrategy.EndsWith:
            return s => s.MyModelField.ToLower().EndsWith(searchItemKey);
        case StrStrategy.Equals:
            return s => s.MyModelField.ToLower().Equals(searchItemKey);
    }
    return defaultStrat;
}

EDIT

I need to call the method for dynamically build predicates to use with Entity Framework queries.

Dennis

If you plan to use result of MatchMyModelFieldByStrategy with Entity Framework or LINQ2SQL, the selector must be an expression instead of delegate, because underlying LINQ providers won't recognize delegate during building entity command text.

Hence, you have to build expression yourself, something like this:

(assuming, that you have similar types:)

enum SearchStrategy
{
    Contains,
    StartsWith,
    EndsWith,
    Equals
}

class SearchItem
{
    public SearchStrategy SearchStrategy { get; set; }
    public string Value { get; set; }
}

Here's the code, which builds the filtering expression:

static class QueryBuilder
{
    private static readonly Lazy<MethodInfo> toLowerMethodInfo;
    private static readonly Dictionary<SearchStrategy, Lazy<MethodInfo>> searchStrategyToMethodInfoMap;

    static QueryBuilder()
    {
        toLowerMethodInfo = new Lazy<MethodInfo>(() => typeof(string).GetMethod("ToLower", new Type[0]));

        searchStrategyToMethodInfoMap = new Dictionary<SearchStrategy, Lazy<MethodInfo>>
        {
            { 
                SearchStrategy.Contains, 
                new Lazy<MethodInfo>(() => typeof(string).GetMethod("Contains", new[] { typeof(string) })) 
            },
            { 
                SearchStrategy.StartsWith, 
                new Lazy<MethodInfo>(() => typeof(string).GetMethod("StartsWith", new[] { typeof(string) })) 
            },
            { 
                SearchStrategy.EndsWith, 
                new Lazy<MethodInfo>(() => typeof(string).GetMethod("EndsWith", new[] { typeof(string) })) 
            },
            { 
                SearchStrategy.Equals, 
                new Lazy<MethodInfo>(() => typeof(string).GetMethod("Equals", new[] { typeof(string) })) 
            },
        };
    }

    public static Expression<Func<T, bool>> MatchMyModelFieldByStrategy<T>(SearchItem searchItem, Expression<Func<T, string>> selector)
    {
        // "doe"
        var searchItemKey = searchItem.Value.ToLower();
        // _.Name.ToLower()
        var toLowerCallExpr = Expression.Call(selector.Body, toLowerMethodInfo.Value);
        // a method we shall use for searching
        var searchMethodInfo = searchStrategyToMethodInfoMap[searchItem.SearchStrategy].Value;

        // _ => _.Name.ToLower().SomeSearchMethod("doe")
        return Expression.Lambda<Func<T, bool>>(
            Expression.Call(toLowerCallExpr, searchMethodInfo, Expression.Constant(searchItemKey)), 
            selector.Parameters);
    }
}

I've added a little laziness to cache reflection results, because for every MatchMyModelFieldByStrategy call they'll be the same.

Now the test entity type:

class MyEntity
{
    public int Id { get; set; }
    public string Name { get; set; }
}

... and the sample code:

    static void Main(string[] args)
    {
        Console.WriteLine(QueryBuilder.MatchMyModelFieldByStrategy<MyEntity>(
            new SearchItem { SearchStrategy = SearchStrategy.Contains, Value = "doe" }, _ => _.Name));
        Console.WriteLine(QueryBuilder.MatchMyModelFieldByStrategy<MyEntity>(
            new SearchItem { SearchStrategy = SearchStrategy.StartsWith, Value = "doe" }, _ => _.Name));
        Console.WriteLine(QueryBuilder.MatchMyModelFieldByStrategy<MyEntity>(
            new SearchItem { SearchStrategy = SearchStrategy.EndsWith, Value = "doe" }, _ => _.Name));
        Console.WriteLine(QueryBuilder.MatchMyModelFieldByStrategy<MyEntity>(
            new SearchItem { SearchStrategy = SearchStrategy.Equals, Value = "doe" }, _ => _.Name));

        Console.ReadLine();
    }

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

TOP Ranking

  1. 1

    Failed to listen on localhost:8000 (reason: Cannot assign requested address)

  2. 2

    Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

  3. 3

    How to import an asset in swift using Bundle.main.path() in a react-native native module

  4. 4

    pump.io port in URL

  5. 5

    Compiler error CS0246 (type or namespace not found) on using Ninject in ASP.NET vNext

  6. 6

    BigQuery - concatenate ignoring NULL

  7. 7

    ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

  8. 8

    ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements

  9. 9

    Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

  10. 10

    How to remove the extra space from right in a webview?

  11. 11

    java.lang.NullPointerException: Cannot read the array length because "<local3>" is null

  12. 12

    Jquery different data trapped from direct mousedown event and simulation via $(this).trigger('mousedown');

  13. 13

    flutter: dropdown item programmatically unselect problem

  14. 14

    How to use merge windows unallocated space into Ubuntu using GParted?

  15. 15

    Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd

  16. 16

    Nuget add packages gives access denied errors

  17. 17

    Svchost high CPU from Microsoft.BingWeather app errors

  18. 18

    Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

  19. 19

    12.04.3--- Dconf Editor won't show com>canonical>unity option

  20. 20

    Any way to remove trailing whitespace *FOR EDITED* lines in Eclipse [for Java]?

  21. 21

    maven-jaxb2-plugin cannot generate classes due to two declarations cause a collision in ObjectFactory class

HotTag

Archive