EntitySqlException: The syntax of the command argument '@0' is invalid.

Different failures based on the object supplied as a parameter when using Dynamic Linq?

Welp I figured this out, Dynamic LINQ doesn't initially support Comparison of GUIDs (so stupid!). I found this little tidbit: ...https://connect.microsoft.com/VisualStudio/feedback/details/333262/system-linq-dynamic-throws-an-error-when-using-guid-equality-in-where-clause...You just go in an edit Dynamics.cs, replace the IEqualitySignatures interfa...

How can I do a distinct on a dynamically selected column?

Instead of using ...as " + this.UniqueName + " ...do...as someFixedColumnName...and run your ...Distinct()... clause on that, using ordinary Linq....Alternatively, you could try ...this extension method:...public static IQueryable DynamicDistinct(this IQueryable source) { if (source == null) throw new ArgumentNullException("source"); return...

How to design a query when the table name is a parameter in Linq To Entities

Linq-to-entities doesn't support that. You can achieve that with ...Entity SQL... or some ugly code which will have conditional logic for every set you want to query (like a big ...switch... for table names).

Dynamic Linq query not working as expected - what am I doing wrong?

From your code it looks like you are operating on the var "query" which is an empty enumerable. Remember, what you have called query is the data set, the Where statement is the query on that data set. So the first query is on an empty data set and it looks like the additional queries from the foreach will just refine that empty set....Also, you can...

Dynamic Linq Any syntax

If you are using this library: ...http://www.nuget.org/packages/System.Linq.Dynamic/... as far as I know it does not allow lambda expressions. However, there is somebody who extended this library. I have never tried it but it looks promising. ...http://dynamiclinq.codeplex.com/... Good luck :)

Dynamic linq syntax for subquery

Consider querying the database on your subquery, then stashing the result in a datatable which you can then compute off of....SELECT value1, dim1, dim2 FROM [BudgetLine] WHERE [BudgetID] = 4 ...MSDN article - Compute

System.Linq.Dynamic - ParseException: syntax error

Looks like you can write: ..."Property == \"MySt\"\"ring\"" ...Here's the tokenization code from System.Linq.Dynamic source code:...case '"': case '\'': char quote = ch; do { NextChar(); while (textPos < textLen && ch != quote) NextChar(); if (textPos == textLen) throw ParseError(textPos, Res.Unterminated...

Natural sort with Dynamic Linq including multiple sorting parameters

DynamicLinq... does not have method ...OrderBy... that takes ...IComparer<T>... as parameters, so you can't pass custom comparer, but you can modify source like this...public static IQueryable<T> OrderBy<T,ComparerType>(this IQueryable<T> source, IComparer<ComparerType> comparer, string ordering, params object[] values) { return (IQueryable<T>)...

How to use linq extensions with Func parameters in Dynamic Linq expressions?

Extending the dynamic library is certainly an option as already suggested. an alternative given the ...Where... in Dynamic Linq returns an Iqueryable... public static class DynamicQueryable { public static IQueryable<T> Where<T>(this IQueryable<T> source, string predicate, params object[] values) { return (IQueryable<T>) Where((IQueryable) sou...

System.Linq.Dynamic.DynamicExpression parsing expressions with enum parameters

Found this answer... and went with patching the sources for the System.Linq.Dynamic library. Downloaded the package sources from GitHub and added System.StringComparison to the "predefinedTypes" array of Types within System.ExpressionParser....UPDATE...: See Stef's answer for a better solution: ...https://stackoverflow.com/a/56472200/785965