The LINQ expression node type ‘ArrayIndex’ is not supported in LINQ to Entities

by

To fix this use a temporary variable:

var tmp = aa[i];
...
m => m.PresId == tmp

In your where clause you have

m => m.PresId == aa[i]

which is a way of expressing a lambda expression. When that is converted to an expression, then converted into a query on your database it finds the aa[i], which is an index into an array. i.e. it doesn’t treat it as a constant. Since a translation of an indexer to your database language is impossible it gives the error.

More Related Contents:

  1. Dynamic where clause (OR) in Linq to Entities
  2. How to create LINQ Expression Tree to select an anonymous type
  3. ‘Contains()’ workaround using Linq to Entities?
  4. “A lambda expression with a statement body cannot be converted to an expression tree”
  5. Bulk-deleting in LINQ to Entities
  6. The type of one of the expressions in the join clause is incorrect in Entity Framework
  7. Entity framework left join
  8. LEFT JOIN in LINQ to entities?
  9. How to compare only date components from DateTime in EF?
  10. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  11. Linq to Entity Join table with multiple OR conditions
  12. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  13. Dynamic query with OR conditions in Entity Framework
  14. Calling a SQL User-defined function in a LINQ query
  15. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  16. How do I concatenate two arrays in C#?
  17. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  18. Entity Framework/Linq EXpression converting from string to int
  19. A specified Include path is not valid. The EntityType does not declare a navigation property with the name *
  20. Error: “The specified LINQ expression contains references to queries that are associated with different contexts”
  21. LINQ to Entities does not recognize the method ‘Int32 Int32(System.String)’ method, and this method cannot be translated into a store expression
  22. linq to entities doesn’t recognize a method
  23. How to group by on 2 child entities and get total of both this child entities?
  24. How to convert an expression tree to a partial SQL query?
  25. Generate EF orderby expression by string [duplicate]
  26. How does LINQ expression syntax work with Include() for eager loading
  27. Only primitive types or enumeration types are supported in this context
  28. linq to entities vs linq to objects – are they the same?
  29. How to include() nested child entity in linq
  30. LINQ Query to Convert string to datetime

Leave a Comment