Using special property names in Dynamic LINQ

Question

I'm constructing a Dynamic LINQ query like this:

"Guid=Guid(\"" + entityId + "\")"

This is eventually passed into a .Where() query, somewhere in the code that I call.

I'm getting this error:

ParseException: '.' or '(' expected

This seems to be because it doesn't find the Guid property, but rather the Guid function.

How can I query on the Guid property of my object?

score 1 · Accepted Answer · answered Dec 10 '13 at 16:39

1

Guid is indeed a keyword. You can escape keyword identifiers by prefixing them with @.

The correct expression looks like this:

"@Guid=Guid(\"" + entityId + "\")"

answered Dec 10 '13 at 16:39

Kendall Frey

score 0 · Answer 2 · answered Aug 15 '14 at 08:33

0

Just to tidy up Kendall's answer I think the more elegant approach is to let Dynamic LINQ handle the type conversions by using parameterized queries.

myIqueryable1.Where("@Guid=@0", entityId)

answered Aug 15 '14 at 08:33

Le-roy Staines

2 Answers2