Dynamic LINQ - Groupby with ExpandoObject Results in Error: No Applicable Indexer

c# dynamic dynamic-linq linq

Question

Is it possible to perform a GroupBy using Dynamic LINQ with an ExpandoObject?

Consider the example below; ideally I'd like a grouped list of ExpandoObjects.

Thank you for your time.

var listOfExpandoObjects = new List<ExpandoObject>();
var expandoObject = new ExpandoObject();
((IDictionary<string, object>)expandoObject).Add("DynamicProperty", "RepeatedItem");
((IDictionary<string, object>)expandoObject).Add("OtherProperty", "First");
listOfExpandoObjects.Add(expandoObject);

expandoObject = new ExpandoObject();
((IDictionary<string, object>)expandoObject).Add("DynamicProperty", "RepeatedItem");
((IDictionary<string, object>)expandoObject).Add("OtherProperty", "Second");
listOfExpandoObjects.Add(expandoObject);

var dynamicGroupBy = "new ( it[\"DynamicProperty\"] )";
var groupedItems = listOfExpandoObjects.GroupBy(dynamicGroupBy, "it"); // <------- Error: 'No applicable indexer exists in type 'ExpandoObject''
1
0
5/7/2017 7:01:17 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

I think you want something like this

dynamic expandoObject = new ExpandoObject();
expandoObject.DynamicProperty = " RepeatedItem";
expandoObject.OtherProperty = "First";

dynamic secondExpandoObject = new ExpandoObject();
secondExpandoObject.DynamicProperty = "RepeatedItem";
secondExpandoObject.OtherProperty = "Second";

var listOfExpandoObjects = new List<dynamic> { expandoObject, secondExpandoObject };

var dynamicProperty = "DynamicProperty";

var groupedItems =
    from IDictionary<string, object> expando in listOfExpandoObjects
    group expando by expando[dynamicProperty];
0
5/7/2017 7:21:02 AM

Related Questions

Using the System.Linq.Dynamic namespace, how to perform the following in Dynamic Linq

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

Does dynamic GroupBy in dynamic LINQ work with dynamic Where?

Found it, ...db.Table1.AsQueryable()... fixed it, so ...db.Table1.AsQueryable().Where("it.FieldA>10").GroupBy("it.FieldB", "it").Select("key") ... works without exception....The problem was that Microsoft Dynamic Linq library extends ...IQueryable<Table1>..., so it does not take effect on... ObjectQuery<Table1>... which is the type of ...db.Table1....
.net dynamic dynamic-linq linq linq-to-entities
asked by alpav

How can I utilize System.Linq.Dynamic for the LIKE operation?

Try using simply "CityName.Contains(@1)" this will convert to the proper lambda since its a method invocation on an accessible type....something like:...var query = db.Customers. Where("CityName.Contains(@0) or CityName.Contains(@1)", "London", "USA") ...Just tested it with the sample app that comes with the dynamic library and it generates the LIK...
asp.net c# dynamic-linq linq
asked by Jaime

OrderBy inside 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

C# Dynamic LINQ: Select with Sum on dictionary indexer

I faced this issue myself; the problem is that ...Sum()... is seeing the column as type ...object... (which can be applied to ...Convert()..., or ...Max()... even, but not ...Sum()...), and thus is failing; note that it says there is no ...applicable... aggregate function....The solution is to use an inline conversion to integer. Dynamic LINQ suppo...
c# dynamic-linq linq select
asked by Eric

How can I access the result of dynamic linq with dynamic key/value pairs of IEnumerable?

you can use reflection like this...foreach (var v in gFieldList) { MessageBox.Show(key.GetType().GetProperty(v).GetValue(key,null)); ...
c# dynamic-linq linq
asked by Grundy

Using Linq.Dynamic where method with a dynamic list gives error

Dynamic LINQ does not work with ...dynamic... type. LINQ to Objects would work, but since you are receiving the filter as ...string..., it's not applicable....The workaround is to use temporary anonymous projection before applying the dynamic ...Where... and then selecting back the original object:...var filtereddata = result .Select(x => new {...
c# dynamic dynamic-linq linq
asked by Ivan Stoev

System.Linq.Dynamic.Core vs System.Linq.Dynamic

System.Linq.Dynamic.Core... is more up to date and has more functionality and does also support NET Core / NETStandard (besides net35, net40 and net45 and up)...SelectMany... is indeed supported....For more information see the ...github... page and browse the examples, unit-tests and help page....Note: I'm the maintainer from this project.
dynamic-linq
asked by Stef Heyenrath

C#, dynamic linq error No applicable method 'Contains' exists in type 'String'

If your application needs dynamic filter capabilities, I would recommend having the caller pass a predicate. ...This allows for a separation of concerns and easier unit testing. ...Also, no need for a IF/ELSE statement when the caller passes a predicate....var predicate = new Predicate<string>(str => str.Contains("one")); var tmp = test.Select(p =...
c# dynamic-linq linq
asked by rschoenbach

Dynamic linq for object collection - Target object is not an ExpandoObject

If you want to use Dynamic Linq on (database) entity classes, you could use ...System.Linq.Dynamic.Core.......With this you can easily write text based linq, like...var query = db.Customers .Where("City == @0 and Orders.Count >= @1", "London", 10) .OrderBy("CompanyName") .Select("new(CompanyName as Name, Phone)");
.net-core .net-core-2.1 c# dynamic-linq reflection
asked by Stef Heyenrath

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