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 discovered that Dynamic LINQ initially did not enable GUID comparison (dumb!). I discovered this interesting fact: ...https://connect.microsoft.com/VisualStudio/feedback/details/333262/system-linq-dynamic-throws-an-error-when-using-guid-equality-in-where-clause...You just update Dynamics.cs and substitute the IEqualitySignatures interface as...

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

rather than utilizing...as " + this.UniqueName + " ...do...as someFixedColumnName...and exercise....Distinct()... a clause on that with a regular Linq....As an alternative, try ...this technique of extension.......public static IQueryable DynamicDistinct(this IQueryable source) { if (source == null) throw new ArgumentNullException("source"); ...

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

That is not supported by linq-to-entities. Using ...SQL Entity.... or some ugly code with conditional logic for each collection you wish to query (such as a large one), you can do it....switch... for names of tables).

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

From your code, it seems that you are performing an operation on the empty enumerable variable "query." Keep in mind that the data set is what you have referred to as the query, and the Where statement is the query on that data set. Since the first query is on an empty data set, it seems that the subsequent foreach searches will just further refine...

Dynamic Linq Any syntax

Using this library? Enter these characters: ...http://www.nuget.org/packages/System.Linq.Dynamic/... As far as I'm aware, lambda expressions are not permitted. There is someone who expanded this library, however. Although I haven't tried it, it seems promising. ...http://dynamiclinq.codeplex.com/... best of luck

Dynamic linq syntax for subquery

Think about doing a database query on your subquery, then saving the results in a datatable so you can use them to perform calculations....SELECT value1, dim1, dim2 FROM [BudgetLine] WHERE [BudgetID] = 4 ...Computer article from MSDN

System.Linq.Dynamic - ParseException: syntax error

You seem to be able to write:..."Property == \"MySt\"\"ring\"" ...The tokenization code is available here in the System.Linq.Dynamic source code:...case '"': case '\'': char quote = ch; do { NextChar(); while (textPos < textLen && ch != quote) NextChar(); if (textPos == textLen) throw ParseError(textPos, ...

Natural sort with Dynamic Linq including multiple sorting parameters

DynamicLinq... is without a method....OrderBy... that demands...IComparer<T>... as arguments, making it impossible to provide a custom comparer, however you may change the source as shown above...public static IQueryable<T> OrderBy<T,ComparerType>(this IQueryable<T> source, IComparer<ComparerType> comparer, string ordering, params object[] values) ...

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

As has previously been proposed, expanding the dynamic library is undoubtedly a possibility. an alternate considering the...Where... the Dynamic An Iqueryable is what Linq returns.... public static class DynamicQueryable { public static IQueryable<T> Where<T>(this IQueryable<T> source, string predicate, params object[] values) { return (IQuery...

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

I got this response... and began patching the System's source code. Dynamic library using Linq. System was introduced after downloading the package files from GitHub. StringComparison using the System's "predefinedTypes" array of Types. ExpressionParser....UPDATE...: A better explanation may be found in Stef's response: ...https://stackoverflow.com...