Getting No generic method 'where' on type 'System.Linq.Queryable' is compatible with the supplied type arguments and arguments

.net c# expression-trees json

Question

I have been writing expression tree for creating lambda expressions dynamically.

To start it up small, I am reading data from a JSON file into an Class object. And trying to build the where condition on two conditions.

string jsonnew = File.ReadAllText(@"C:\Users\nested_Json.txt");

var rootObject1 = JsonConvert.DeserializeObject<Citizen>(jsonnew);

IEnumerable<Citizen> enumerable = new[] { rootObject1 };

IQueryable<Citizen> queryableDataaa = enumerable.AsQueryable();

        ParameterExpression pe1 = Expression.Parameter(typeof(string), "rootobject");

        PropertyInfo field = typeof(Citizen).GetProperty("name");
        PropertyInfo field2 = typeof(Citizen).GetProperty("id");
        ParameterExpression targetExp = Expression.Parameter(typeof(Citizen), "rootobject");
        ParameterExpression valueExp = Expression.Parameter(typeof(string), "\"StrozeR\"");
        ParameterExpression valueExp2 = Expression.Parameter(typeof(Int32),"1765116");
        MemberExpression fieldExp = Expression.Property(targetExp, field);
        MemberExpression fieldExp2 = Expression.Property(targetExp, field2);
       Expression assignExp = Expression.Equal(fieldExp, valueExp);
       Expression assignExp2 = Expression.Equal(fieldExp2, valueExp2);

Expression predicateBody1 = Expression.AndAlso(assignExp, assignExp2);

MethodCallExpression whereCallExpression1 = Expression.Call(
            typeof(Queryable),
            "where",
            new Type[] { queryableDataaa.ElementType},
            queryableDataaa.Expression,
            Expression.Lambda<Func<string, bool>>(predicateBody1, new ParameterExpression[] { pe1 }));

Can anyone help me out in understand why I am getting

No generic method 'where' on type 'System.Linq.Queryable' is compatible with the supplied type arguments and arguments. No type arguments should be provided if the method is non-generic. error

1
2
7/4/2017 7:56:59 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You must

  • use constant expressions for your values
  • use one argument with type Citizen for the whole where clause expression
  • find the Where(with capital w) method of IQueryable where is an extension method defined in System.Linq.Queryable, then provide it's generic type
  • invoke the method with appropriate parameters

here is the corrected code:

var targetExp = Expression.Parameter(typeof(Citizen), "rootobject");
var valueExp = Expression.Constant("\"StrozeR\"");
var valueExp2 = Expression.Constant(1765116);
var fieldExp = Expression.Property(targetExp, "name");
var fieldExp2 = Expression.Property(targetExp, "id");
var assignExp = Expression.Equal(fieldExp, valueExp);
var assignExp2 = Expression.Equal(fieldExp2, valueExp2);
var predicateBody1 = Expression.AndAlso(assignExp, assignExp2);

var queryableType = typeof(System.Linq.Queryable);
var whereMethod = queryableType.GetMethods()
       .First(m =>
       {
           var parameters = m.GetParameters().ToList();
           //Put more restriction here to ensure selecting the right overload                
           //the first overload that has 2 parameters
           return m.Name == "Where" && m.IsGenericMethodDefinition &&
                 parameters.Count == 2;
       });
var whereClause = Expression.Lambda<Func<Citizen, bool>>(predicateBody1, 
                  new ParameterExpression[] { targetExp });
var genericMethod = whereMethod.MakeGenericMethod(typeof(Citizen));
var newQuery = (IQueryable<Citizen>)genericMethod
              .Invoke(genericMethod, new object[] { queryableDataaa, whereClause });
4
8/19/2015 3:30:34 AM

Related Questions

Where Predicate Type Arguments in C#

I have an XElement with values for mock data. ...I have an expression to query the xml:...Expression<Func<XElement, bool>> simpleXmlFunction = b => int.Parse(b.Element("FooId").Value) == 12; ...used in:...var simpleXml = xml.Elements("Foo").Where(simpleXmlFunction).First(); ...The design time error is:...The type arguments for method 'System....
c# entity-framework expression-trees lambda
asked by blu

With the "provided parameters," I can't locate OrderBy on Queryable.

Since you want your property selector expression to make the appropriate calls dynamically, you must create a new expression for it. You cannot use the provided selector as-is since it is currently typed ...Expression<Func<T, object>>... and not returning your specific type ...Expression<Func<T, SomeType>>.... You might be able to get it to compi...
c# expression-trees linq
asked by Jeff Mercado

For the return type 'System.Object,' an expression of type 'System.DateTime' cannot be used.

I've created an expression that I'm using for sorting which works fine, until I hit a ...DateTime... field, where I get the following error (on the second line):...Expression of type 'System.DateTime' cannot be used for return type 'System.Object'...Here's my code:...ParameterExpression param = Expression.Parameter(typeof(MyEntity), "x"); Expres...
c# expression expression-trees linq
asked by Wildcat

For delegate parameters of type 'System.String,' a parameterExpression of type 'System.Int32' cannot be used.

I'm creating a general setter using expression tree and here is my code...public Expression<Action<T,string>> GetAction<T>(string fieldName) { ParameterExpression targetExpr = Expression.Parameter(typeof(T), "Target"); MemberExpression fieldExpr = Expression.Property(targetExpr, fieldName); ParameterExpression valueExpr = Expressi...
c# delegates dynamic expression-trees generics
asked by kans

Unable to cast object of type 'System.Linq.Expressions.UnaryExpression' to type 'System.Linq.Expressions.MemberExpression'

I created a ...method in C#... to get methodname...public string GetCorrectPropertyName<T>(Expression<Func<T, string>> expression) { return ((MemberExpression)expression.Body).Member.Name; // Failure Point } ...and calling it as...string lcl_name = false; public string Name { get { return lcl_name ; } set { lcl_name = value; ...
c# exception-handling expression-trees linq
asked by Nikhil Agrawal

System.ArgumentException: Incorrect number of parameters supplied for lambda declaration in System.Linq.Expressions method

This is the initial problem, I think:...Expression.Lambda<Func<string, bool>>(predicateBody, new ParameterExpression[] { pe1, pe2 })) ...A ...Func<string, bool>... takes just a ...string... and returns a ...bool.... So it only has a single parameter. You're passing in ...two...ParameterExpressions.... Also, the...
.net c# expression-trees linq linq-to-sql
asked by Jon Skeet

ParameterExpression of type 'MyClass' cannot be used for delegate parameter of type 'System.Object'

I've built an expression tree of type ...Func<object,bool>.... But when I try to compile it I get exception: ...ParameterExpression of type 'MyClass' cannot be used for delegate parameter of type 'System.Object'...The type of the calling object is unknown until run-time....Expression leftFunc, rightFunc; var x = Expression.Parameter(t); if (left_el...
c# expression-trees lambda linq
asked by Szolnoki Ádám

Expression of type 'System.Int64' cannot be used for return type 'System.Object'

I am trying to create an expression of the following form:...e => e.CreationDate; ...CreationDate... is of type ...long..., however I want the expression to return an ...object... instead....I want to use ...object... as a return type because the expression is built dynamically at runtime based on a query paramater. The query parameter specifies th...
.net c# expression-trees linq reflection
asked by Matias Cicero

The type arguments for method Queryable.Select cannot be inferred from the usage

I'll quote @Ivan Stoev...The problem is that ...TResult... needs to be known at compile time, so ...linqQuery... (must) be ...IQueryable<string>..., or ...IQueryable<int>... etc. It's not possible to resolve the type of ...var... at runtime. It's possible to emit the call to ...Select... dynamically, but all you can get will be a non generic ...IQu...
c# expression expression-trees lambda linq
asked by xanatos

'Argument expression is not valid' when creating anonymous types dynamically

This is because ...call... returns dynamically created ...ReturnType... not ...IdName... thus the exception. Additionally you cannot put such dynamic types like ...ReturnType... as generic type parameters because compiler knows nothing about them so you should use ...dynamic... instead so the type will be resolved at runtime:...var qResult = allCar...
expression-trees linq typebuilder
asked by arekzyla

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow