Expression of type 'T' expected when using Dynamic Linq

c# dynamic-linq linq

Question

I'm using the Dynamic Linq Library in my .NET MVC application to query a SQL Server database. It's all working fine so far.

I need to make a dynamic select but always return Expression of type 'T' expected:

public static IQueryable<T> SelectByFields<T>(this IQueryable<T> q, string expression, params object[] values) // IEnumerable<string> fieldNames)
{
    try
    {
        var param = Expression.Parameter(typeof(T), "p");
        var lambda = System.Linq.Dynamic.DynamicExpression.ParseLambda(new ParameterExpression[] { param }, typeof(T), expression, values);

        Type[] types = new Type[] { q.ElementType, lambda.Body.Type };
        return q.Provider.CreateQuery<T>(Expression.Call(typeof(Queryable), "Select", types, q.Expression, Expression.Quote(lambda)));
    }
    catch
    {
        return q;
    }
1
0
9/10/2016 1:35:29 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Finally I solve the problem

public static IQueryable SelectByFields(this IQueryable q, string expression, params object[] values) // IEnumerable<string> fieldNames)
    {
        try
        {
            if (q == null)
                throw new ArgumentNullException("source");

            if (expression == null) 
                throw new ArgumentNullException("selector");

            LambdaExpression lambda = System.Linq.Dynamic.DynamicExpression.ParseLambda(q.ElementType, null, expression, values);
            Type[] types = new Type[] { q.ElementType, lambda.Body.Type };

            return q.Provider.CreateQuery(Expression.Call(typeof(Queryable), "Select", types, q.Expression, Expression.Quote(lambda)));
        }
        catch
        {
            return q;
        }
    }

And call to method

var aux = context.CLIENTES.SelectByFields("new (ID)") as IQueryable<Object>;
0
1/19/2015 7:23:39 AM

Related Questions

Dynamic Linq - Setting orderby expression type at runtime

Looks like the dynamic Linq extension methods take care of it all for me. I was making it too hard....var result = from item in table.Where("owner = \"joe\"").OrderBy("inserted") select item; result.ToList().ForEach(m => Console.WriteLine("inserted=" + m.Inserted + "."));
c# dynamic-linq
asked by sipwiz

How to do the following in Dynamic Linq using System.Linq.Dynamic namespace

I tried this:...using System; using System.Linq; using System.Linq.Dynamic; using System.Collections.Generic; namespace ConsoleApplication1 { public class Customer { public string FirstName { get; set; } public string LastName { get; set; } public string Tags { get; set; } } class Program { sta...
dynamic-linq linq
asked by MattC

Entity Data Model, Dynamic Linq, multiple table dynamic Where clause, strongly typed return types

The solution to my particular query was to do this:... var query = from pl in CurrentDataSource.ProductListing join pla in CurrentDataSource.ProductListingAttribute on new {pl.ProductID, pl.WebCategoryID, pl.ParentProductID} equals new {pla.Pro...
anonymous-types c# dynamic-linq linq-to-entities
asked by rposbo

LINQ (Dynamic): OrderBy within a GroupBy using dynamic linq?

This is a good question!...I simulated your situation by creating a class called Item....public class Item { public DateTime StartTime { get; set; } public string Name { get; set; } } ...and then created a basic list of items to do the groupby....List<Item> Items = new List<Item>() { new Item() { StartTime = DateTime.Today, Name = "item...
dynamic-linq linq linq-to-objects
asked by Bengel

How to use Dynamic LINQ to query expressions on different object types at the same time

You could give your ...FileMetabaseObject... an abstract read-only string property called ...Value..., then override it in all child classes:...public abstract class FileMetabaseObject { public abstract string Value { get; } } public class FileTag : FileMetabaseObject { public string Tag { get; set; } public override string Value { get...
c# dynamic-linq linq
asked by sq33G

Dynamic Linq - Perform a query on an object with members of type "dynamic"

Are ...dynamic... members incompatible with Dynamic Linq queries?, or is there another way of constructing expressions that would evaluate properly when dealing with members of type ...dynamic...?...Both can work together. Just do a conversion to Int32 before doing the comparison like so:...IEnumerable<DataItem> result = repository.AsQu...
c# dynamic-linq expression-trees lambda
asked by afrischke

How to add an AND/OR expression to the following dynamic linq expression

I'm not quite sure if I have understood you correctly, but I think I was in the same situation a few months ago. The posted code ... here ... was my solution....I think you should be especially interested in line 24....Edit:...PropertyInfo p = ... // I used reflection in my examply to get properties with a certain Attribute var expressionParameter...
.net c# dynamic-linq expression-trees linq
asked by MarcusK

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...
dynamic-linq extension-methods linq
asked by phil soady

Using Radgrid filter expression to query collection gives exception 'Expression Expected'

Instead of using the filter expression of the rad grid I decided to use a different approach and use the current data in the rad grid itself when a filter is applied:... // If there is a filter applied then enter the loop if there isn't then the filter expression will be empty if (!String.IsNullOrEmpty(filterExpression)) { ...
asp.net c# dynamic-linq telerik telerik-grid
asked by Myers

Select Clause using System.Linq.Dynamic is returning "'(' expected" fault

The main question from your example is "what is outerIt?" (...@1.Contains(outerIt.Id)...) This looks to be just a piece of a larger query. You may want to post up the complete set of expressions....Based on an assumption of what it looks like you are after: It may be possible within a single Linq statement, but often I hit weird-isms around Linq2En...
c# dynamic-linq linq linq-to-sql
asked by Steve Py

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