DevForce Community Forum : Linq anonymous type sub collection query http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Linq anonymous type sub collection query Fri, 24 May 2013 04:50:12 -700 Tue, 10 May 2011 12:47:30 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2655 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Linq anonymous type sub collection query : Hi Tersius, Try running the... http://www.ideablade.com/forum/forum_posts.asp?TID=2655&PID=10626#10626 Author: sbelini
Subject: 2655
Posted: 10-May-2011 at 12:47pm

Hi Tersius,
 
Try running the query against the CacheOnly. (You will need to load all VehiclesMakes and VehicleModels in the cache first - but that you do with your query anyhow)
 
Silvio.


Edited by sbelini - 10-May-2011 at 12:52pm]]> Tue, 10 May 2011 12:47:30 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2655&PID=10626#10626 Linq anonymous type sub collection query : HiThanks. In the meantime is... http://www.ideablade.com/forum/forum_posts.asp?TID=2655&PID=10620#10620 Author: tersiusk
Subject: 2655
Posted: 10-May-2011 at 12:04am

Hi

Thanks. In the meantime is there any other way I can get the same sort of results? 

edit: It seems to work if you use a concrete type.

Regards


Edited by tersiusk - 10-May-2011 at 2:13am]]> Tue, 10 May 2011 00:04:24 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2655&PID=10620#10620 Linq anonymous type sub collection query : Hi Tersius, I have verified... http://www.ideablade.com/forum/forum_posts.asp?TID=2655&PID=10616#10616 Author: sbelini
Subject: 2655
Posted: 09-May-2011 at 3:57pm

Hi Tersius,
 
I have verified and this is indeed a bug.
We have already filed a bug and I will let you know as soon as we have a fix for it.
 
Regards,
Silvio.
]]> Mon, 09 May 2011 15:57:33 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2655&PID=10616#10616 Linq anonymous type sub collection query : Hi I'm trying to execute... http://www.ideablade.com/forum/forum_posts.asp?TID=2655&PID=10610#10610 Author: tersiusk
Subject: 2655
Posted: 09-May-2011 at 5:49am

Hi I'm trying to execute the following query but the result has the following error.

Also when I run this with normal entity framework the code executes and results are fine. Is this a bug? If so are there any kind of work around you can suggest?

"Unable to cast object of type 'System.Object[]' to type 'System.Collections.Generic.IEnumerable`1[<>f__AnonymousType0`3[System.Int64,System.String,System.String]]'."
 var query = (EntityQuery)(from makes in em.VehicleMakes                                      orderby makes.MakeName                                      select new                                      {                                          Key = makes.VehicleMakeId,                                          Name = makes.MakeName,                                          Description = makes.MakeCode,                                          Children = from model in makes.VehicleModels                                                     select new                                                     {                                                         Key = model.VehicleModelId,                                                         Name = model.ModelName,                                                         Description = model.ModelCode                                                     }                                      });


Edited by tersiusk - 09-May-2011 at 6:22am]]> Mon, 09 May 2011 05:49:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2655&PID=10610#10610