Can somebody please help? Type parameters cannot be determined from use.

c# compiler-errors dynamic-linq linq linq-to-objects

Question

I am trying to use Dynamic Linq (the one published by ScottGu) to do a GroupBy (lambda expression). I have an object. And i am doing AsQueryable. THis is what i have..

var result = Items.AsQueryable().GroupBy("DeliveryDate");

but it gives me an error saying that arguments cannot be inferred from usage. I think its not looking at the right OrderBy.

Items is a List<Stock>.

I tried adding the < > to GroupBy but i think i need to pass more than 1 item. I am a little confused.

The field that i am passing in (via a string) could be any type, in this example it is a DateTime.

If I do my standard LINQ it does work. i.e.:

var result = Items.AsQueryable().GroupBy( x => x.DeliveryDate);

Here is the extension method (from ScottGu):

public static IQueryable GroupBy(this IQueryable source, string keySelector, string elementSelector, params object[] values) {
    if (source == null) throw new ArgumentNullException("source");
    if (keySelector == null) throw new ArgumentNullException("keySelector");
    if (elementSelector == null) throw new ArgumentNullException("elementSelector");
    LambdaExpression keyLambda = DynamicExpression.ParseLambda(source.ElementType, null, keySelector, values);
    LambdaExpression elementLambda = DynamicExpression.ParseLambda(source.ElementType, null, elementSelector, values);
    return source.Provider.CreateQuery(
        Expression.Call(
            typeof(Queryable), "GroupBy",
            new Type[] { source.ElementType, keyLambda.Body.Type, elementLambda.Body.Type },
            source.Expression, Expression.Quote(keyLambda), Expression.Quote(elementLambda)));
}

I have the using in the project using System.Linq.Dynamic; - and i am using dynamic OrderBy in another method, so i know it should be able to see it.

I am a little confused, it seems using dynamic LINQ it doesn't understand what object I am using.

1
3
9/21/2011 11:22:39 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

The extension method with this signature

public static IQueryable GroupBy(this IQueryable source, 
        string keySelector, string elementSelector, params object[] values)

isn't being invoked by this line

var result =  Items.AsQueryable().GroupBy("DeliveryDate");

as there's only one non-this argument! So the compiler thinks you're after the regular GroupBy (that takes a Func) and gets confused.

You need to supply the other selector string.

edit to add

The normal GroupBy has lots of overloads, and so Dynamic Linq needs to offer just as much flexibility. GroupBy produces a sequence of groupings each of which has a key and a sequence of elements. If, as in your conventional LINQ call, no mention is made of the elements, the source objects themselves are used as elements.

For example, using some hypothetical classes, grouping Orders by OrderDate produces an IEnumerable<IGrouping<DateTime, Order>>.

But we could say that we only care about the OrderId in the output, so we could give GroupBy an elementSelector to make it produce an IEnumerable<IGrouping<DateTime, int>>.

To tell Dynamic Linq to use the Item itself as the element, we use the magic string "it" as the elementSelector:

var result = Items.AsQueryable().GroupBy("DeliveryDate", "it");

This should then have the same effect as the conventional LINQ call

var result = Items.AsQueryable().GroupBy(i => i.DeliveryDate);
5
9/21/2011 10:40:55 AM

Related Questions

Help with the Dynamic Linq Library

I have the following class:...public class Item { public Dictionary<string, string> Data { get; set; } } ...and a list of it:...List<Item> items; ...I need to filter and order this list dynamically using SQL-Like strings. The catch is, that I need to order it by the Data dictionary. ...For example: ...Order By Data["last...
c# dynamic-linq linq
asked by Alon Gubkin

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...
dynamic-linq generics linq linq-to-sql where-clause
asked by SventoryMang

Multiple table dynamic, Entity Data Model, Dynamic Linq Strongly typed return types, when clause

When writing a method for an oData service I have the below linq, for which I need to have a dynamic "where" clause to filter the results (the "new"s in the joins are for composite PKs in the Entity Data Model):...var query = from pl in CurrentDataSource.ProductListing join pla in CurrentDataSource.ProductListingAttribute ...
anonymous-types c# dynamic-linq linq-to-entities
asked by rposbo

Need assistance with a LINQ query created using the Dynamic LINQ Library?

Forgive my ignorance on this. I have this LINQ Query: Dim ngBikersDataContext As New CarBikeWalkDataContext...bikersList = (From c In ngBikersDataContext.Reg_Bikers _ Order By c.L_Name _ Select New Bikers() With { _ .BikerID = c.BikerID, _ .F_Name = c.F_...
dynamic-linq linq vb.net
asked by Matt Porterfield

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

I am using dynamic linq and selecting a column dynamically. I need to do a distinct on this. How could I do this?...var qry = tbl.AsEnumerable().AsQueryable() .Select("new(it[\"" + this.UniqueName + "\"] .ToString() as " + this.UniqueName + ")"); ...Thanks.
dynamic-linq linq
asked by Graci

Dynamic Linq query on a base type collection to retrieve type-specific characteristics

How can I run a dynamic LINQ query on a collection of a base type (like the IPerson interface) but access implementation specific properties (like Age)....I can be sure that all items in the collection are the same, i.e. looking at the first type I can assume that the others are the same....I need this for a UI that can apply filters to different c...
c# dynamic-linq linq
asked by lukebuehler

Dynamic Linq searching multiple columns of multiple types including nullable types

I need select my columns dynamically and I do not know the types of the columns ahead of time. I've got a string and I want to search all the columns if they contain that string, converting non-string into string for the comparison....string format = "Convert.ToString({0}).Contains(@0)"; Model.Where(String.Format(format, columnName), searchString);...
c# dynamic-linq expression-trees linq
asked by Kyle

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...
c# dynamic-linq linq
asked by Thabo

Cannot check the same property twice using dynamic linq

I'm building an MVC app which will have to build dynamic linq queries to the server, and I'm facing something that puzzles me....Up to now I'm able to make a query like this:...var objQry = from o in m_DB.OBJECTS.Where(whereConditions) select c; if(!objQry.Any()) { return null; } ...And this works fine. The "whereConditions" varia...
asp.net-mvc c# dynamic-linq linq
asked by hsim

How to convert an anonymous type in Dynamic LINQ to a strong type

This is a bit of a multi-faceted question, so let me just dive into the code with some explanation at the bottom....Example Sample Data:...List<Encounter> input Id, Facility, HospitalService, Field3, Field4, Field5, ... 1, 1, A, ..., ..., ... 2, 2, A, ..., ..., ... 3, 1, B, ...
anonymous-types c# dynamic-linq linq
asked by Raymond

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