DevForce Community Forum : Eager Load Weird Issue http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Eager Load Weird Issue Tue, 12 May 2026 22:30:08 -700 Tue, 26 Feb 2013 09:24:45 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3999 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Eager Load Weird Issue : No, the logic for ObjectQuery... http://www.ideablade.com/forum/forum_posts.asp?TID=3999&PID=15917#15917 Author: kimj
Subject: 3999
Posted: 26-Feb-2013 at 9:24am

No, the logic for ObjectQuery construction is not that sophisticated.   An error during query construction could prevent the Include methods from being processed, so check your server-side debug log for anything unusual there.]]> Tue, 26 Feb 2013 09:24:45 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3999&PID=15917#15917 Eager Load Weird Issue : Hmmm, is it possible that you... http://www.ideablade.com/forum/forum_posts.asp?TID=3999&PID=15916#15916 Author: Vonzkie
Subject: 3999
Posted: 26-Feb-2013 at 1:36am

Hmmm, is it possible that you have an exception to the rule based on different scenario on OS/IIS/SQL/Memory/Threads that let's your framework convert the supposedly Eagerloaded ObjectQuery into a Lazy Loaded Object Query?

Thanks,
Von 
]]> Tue, 26 Feb 2013 01:36:40 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3999&PID=15916#15916 Eager Load Weird Issue : Von, we're not investigating... http://www.ideablade.com/forum/forum_posts.asp?TID=3999&PID=15897#15897 Author: kimj
Subject: 3999
Posted: 22-Feb-2013 at 8:31am

Von, we're not investigating this further.  It's not something we've seen, and it's also not caused by DevForce.  If I were you I'd carefully look at the OS/IIS/SQL configurations on the different servers, and maybe post to StackOverflow or the EF forum to see if anyone has seen the problem.  ]]> Fri, 22 Feb 2013 08:31:21 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3999&PID=15897#15897 Eager Load Weird Issue : Hi,The version of our EF is 4.3.1,... http://www.ideablade.com/forum/forum_posts.asp?TID=3999&PID=15894#15894 Author: Vonzkie
Subject: 3999
Posted: 21-Feb-2013 at 11:33pm

Hi,

The version of our EF is 4.3.1, the edition of our SQL is Standard but right now it's working but we didn't do something on it.. I'm not sure what causes it and when it happens again, we don't know what to check or configure.. Please let us know on your investigation so that we will have a workaround when it happened again.

Thanks,
Von
]]> Thu, 21 Feb 2013 23:33:57 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3999&PID=15894#15894 Eager Load Weird Issue : We haven't seen this... http://www.ideablade.com/forum/forum_posts.asp?TID=3999&PID=15891#15891 Author: kimj
Subject: 3999
Posted: 21-Feb-2013 at 7:40am

We haven't seen this issue before.
 
DevForce will convert the EntityQuery with the Include statements into the corresponding EF ObjectQuery, and allow EF to execute it.  EF uses an ADO.NET data provider to convert the query into SQL appropriate for the database.   We haven't seen multiple SQL queries produced from a single EF query, but it's possible that either the data provider, or the database execution plan, is causing this.   I'd first check the provider version on the server in question, and also the EntityFramework.dll version, and anything else that might differ on this one server.
]]> Thu, 21 Feb 2013 07:40:16 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3999&PID=15891#15891 Eager Load Weird Issue : Hi,Do you have a known issue... http://www.ideablade.com/forum/forum_posts.asp?TID=3999&PID=15888#15888 Author: Vonzkie
Subject: 3999
Posted: 21-Feb-2013 at 1:15am

Hi,

Do you have a known issue on Eager Load not working on Code First 6.1.9.0 in some cases?
We have a Windows Form Application and upon launching of the first form, we have a query that includes other related tables. On one of our servers, when we do a sql server profile, the query is executed one by one, just like how lazy loading does.. but to all of our servers it inner joins it and everything is working fine.
Btw, we are connecting to that server via internet, but we also have other servers that we connect via internet but this issue doesn't happen. The BOS Application used is the same to all of our servers.

I'm reporting this because it is an impediment in our part.
What happened is that other forms in our application doesn't show data maybe because the execution of the first query is not yet finished. Our first query is a medium size query that includes related tables (supposedly).
The average query time is 1-2 seconds, but on one of our servers, since it does a weird lazy loading, it tooks around 3-5 minutes to finished.

Thanks,
Von




Edited by Vonzkie - 21-Feb-2013 at 1:23am]]> Thu, 21 Feb 2013 01:15:26 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3999&PID=15888#15888