Dynamic linq with where clause --- contains

I have a dynamic linq query with contains condition in it. But it gives me the following error: -

No applicable method 'Contains' exists in type 'Int32'

fc.Colvalue[0] is 'int' datatype.

coln = fc.Colname;
 colv = fc.Colvalue[0].ToString();
 value = coln + ".Contains" + "(" + colv + ")";

 inputdata = inputdata.AsQueryable().Where(value).ToList();

Re: Dynamic linq with where clause --- contains

it is trying to run Contains on a NULL - and where does that NULL come from? A tricky little property in yourControlParameter that defaults to true, and you have to manually change it to false:

ConvertEmptyStringToNull="false"

see here more:

http://naspinski.net/post/No-applicable-method-Contains-exists-in-type-String.aspx

Re: Dynamic linq with where clause --- contains

Hello @black

Would you mind showing us the full codes

Re: Dynamic linq with where clause --- contains

Its not a control its a list which holds values

Re: Dynamic linq with where clause --- contains

@Decker :-

Here it is .......

public class FilterContract
    {
        public enum FilterOperator
        {
            Greaterthan,
            Lessthan,
            Equalto,
            In,
            Rangenum,
            Rangedate,
            Startswith,
            Like
        }

        public string Colname { get; set; }

        public List<object> Colvalue { get; set; }

        public FilterOperator Filteroperator { get; set; }
    }


and here is the place where i am using the code in Switch case.


-------------------------------

public static GridServiceOutPut GetFilteredDataTemp<T>(GridInput gridinput, List<T> inputdata)

{

foreach (FilterContract fc in gridinput.FilContract)

{

var coln = string.Empty;

var colv = string.Empty;

string value = string.Empty;

switch (fc.Filteroperator)

{

case FilterContract.FilterOperator.Equalto:

coln = fc.Colname;

colv = fc.Colvalue[0].ToString();

value = coln +

"=" + colv;

inputdata = inputdata.AsQueryable().Where(value).ToList();

break;

case FilterContract.FilterOperator.Like:

coln = fc.Colname;

colv = fc.Colvalue[0].ToString();

value = coln +

".Contains" + "(" + colv + ")";

inputdata = inputdata.AsQueryable().Where(value).ToList();

break;

}

Re: Dynamic linq with where clause --- contains

@black
public List<object> Colvalue { get; set; }

First I'd like to say that List<object>'s defination isn't so goodList<T> for you to define a generic List of specific type Tand we don't use objectMaybe you can use ArrayList instead

And now your main question is that you should add a single quote

".Contains" + "('" + colv + "')";

Or just use parameter+value

http://stackoverflow.com/questions/2455659/how-to-use-contains-or-like-in-a-dynamic-linq-query

Re: Dynamic linq with where clause --- contains

Used single paranthesis as suggested. It gives error as "Character literal must contain exactly one character"

Re: Dynamic linq with where clause --- contains

@black

Used single paranthesis as suggested. It gives error as "Character literal must contain exactly one character"

What did you writeIt should be

.Where("MyColumn.Contains(@0)", "your value here")