How to write a dynamic where 'like' query in Entity framework?

Question

Here is my code:

//order my baselist is context.Entity 
public static GridData Getdata<T>(ObjectSet<T> baseList,
    int currentPage,
    int rowsPerPage,
    string sortcolumn,
    string sortord,
    string searchQuery,
    string searchColumns)where T: class{
var query = baseList.OrderBy("it." + sortcolumn + " " + sortord);
        string strPredicate = string.Empty;
        if (!string.IsNullOrEmpty(searchColumns))
        {
            strPredicate = "it." + searchColumns + " LIKE   @" + searchColumns + "  ";

            query = baseList.Where(strPredicate, new ObjectParameter(searchColumns, searchQuery)).OrderBy("it." + sortcolumn + " " + sortord);
        }
}

My problem is i am trying to write down or form a like query in entity framework and seems like it does not support it.

score 3 · Answer 1 · edited May 23 '17 at 11:50

3

You can use .Contains which is the LIKE operator equivalent in entity framework.

edited May 23 '17 at 11:50

Community

1
1

answered Oct 27 '12 at 19:55

Kamyar

18,639
9
97
171

score 1 · Accepted Answer · answered Oct 29 '12 at 05:51

1

you can use this

 query = baseList.Where(baseli=>baseli.Contains(searchColumns )).OrderBy("it." + sortcolumn + " " + sortord);

:)

answered Oct 29 '12 at 05:51

Kaps Hasija

2,097
5
23
31

How to write a dynamic where 'like' query in Entity framework?

2 Answers2