I am trying to select the fields that start with something using dynamic querylibrary, I am limited to using the column name and fields to be in variables. I have tried:
var x = myqueriable.Where("" + X1 + " LIKE @0 and " + X2 + "= @1 ", Y1 + "%", Y2);
i have error: "system.Linq.Dynamic.ParseException: Expression of type Boolean expected>
Is there a way to accomplish the mentioned?
var x = myQueryable.Where(y => y.StartsWith(param0));