DevForce Community Forum : Include() combined with FirstOrDefault() http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Include() combined with FirstOrDefault() Tue, 28 Apr 2026 05:00:54 -700 Mon, 16 Mar 2009 08:47:04 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1139 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Include() combined with FirstOrDefault() : Ok thanks for the info. http://www.ideablade.com/forum/forum_posts.asp?TID=1139&PID=4085#4085 Author: ken.nelson
Subject: 1139
Posted: 16-Mar-2009 at 8:47am

Ok thanks for the info.]]> Mon, 16 Mar 2009 08:47:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1139&PID=4085#4085 Include() combined with FirstOrDefault() : This is actually a known bug which... http://www.ideablade.com/forum/forum_posts.asp?TID=1139&PID=4074#4074 Author: kimj
Subject: 1139
Posted: 13-Mar-2009 at 4:46pm

This is actually a known bug which we'd hoped to fix in the 4.3.0 release but did not.  You can use the .Execute() or .ToList() methods as a workaround for now, but more data will be returned than wanted.  Using either of these will submit the full query to EF and the database and then invoke FirstOrDefault() on the results returned to the EM cache. ]]> Fri, 13 Mar 2009 16:46:29 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1139&PID=4074#4074 Include() combined with FirstOrDefault() : Hi, Have you tried doing this?em.Customer.Where(i... http://www.ideablade.com/forum/forum_posts.asp?TID=1139&PID=4071#4071 Author: smi-mark
Subject: 1139
Posted: 13-Mar-2009 at 11:47am

Hi,

Have you tried doing this?

em.Customer.Where(i => i.Name.BeginsWith("R")).Include("Orders").ToList().FirstOrDefault();
]]> Fri, 13 Mar 2009 11:47:14 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1139&PID=4071#4071 Include() combined with FirstOrDefault() : Hello, In Microsoft EF, we were... http://www.ideablade.com/forum/forum_posts.asp?TID=1139&PID=4063#4063 Author: ken.nelson
Subject: 1139
Posted: 13-Mar-2009 at 8:02am

Hello,

In Microsoft EF, we were able to do something like the following:

// In Microsoft EF, c.Orders.Count == 7
Customer c = em.Customer.Where(i => i.Name.BeginsWith("R")).Include("Orders").FirstOrDefault();
if (c != null)
     Console.WriteLine(c.Orders.Count);
 
And as expected, the first Customer or null would be returned, and if not null the print out of the number of orders would be accurate.  When we try the same in DevForce EF it doesn't appear to work the same.  (I need to note that we're talking straight DevForce EF here, not SL).  The Customer will come back, but the number of orders is always 0, as if the Include() is not being used.
 
// In DevForceEF, c.Orders.Count == 0
Customer c = em.Customer.Where(i => i.Name.BeginsWith("R")).Include("Orders").FirstOrDefault();
if (c != null)
     Console.WriteLine(c.Orders.Count);
 
What does seem to work is either of the following:
 
Customer c = null;
foreach (var item in em.Customer.Where(i => i.Name.BeginsWith("R")).Include("Orders"))
{
     c = item;
     break;
}
if (c != null)
     Console.WriteLine(c.Orders.Count);
 
Or:
 
Customer c = em.Customer.Where(i => i.Name.BeginsWith("R")).Include("Orders").Execute().FirstOrDefault();
if (c != null)
     Console.WriteLine(c.Orders.Count);
 
However, if we change the FirstOrDefault() to FirstOrNullEntity(), the "Execute()" solution will fail to compile.
 
Is this working as expected or are we doing something wrong?
 
Thanks,
Ken
 


Edited by ken.nelson - 13-Mar-2009 at 11:15am]]> Fri, 13 Mar 2009 08:02:29 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1139&PID=4063#4063