DevForce Community Forum : Include() and FirstOrNullEntity()

Include() and FirstOrNullEntity() : Glad you found the issue. Thanks...

Mon, 31 Jan 2011 17:08:23 -700

Author: sbelini
Subject: 2475
Posted: 31-Jan-2011 at 5:08pm

Glad you found the issue.

Thanks for the update.

Silvio.

Include() and FirstOrNullEntity() : Figured it out; types were not...

Mon, 31 Jan 2011 16:53:19 -700

Author: JulianBenjamin
Subject: 2475
Posted: 31-Jan-2011 at 4:53pm

Figured it out; types were not the same (char15 vs varchar15); after setting the types to be the same, it worked correctly.

Include() and FirstOrNullEntity() : I'm unable to reproduce with...

Mon, 31 Jan 2011 13:37:32 -700

Author: JulianBenjamin
Subject: 2475
Posted: 31-Jan-2011 at 1:37pm

I'm unable to reproduce with the NorthwindIB database. I selected an InternationalOrder with an Include("Order") and got the first entity and pulling the Order record was fine. My model had a similar association key (as400_itemex01 always has a record, but there may not be a b2b_product record for it).

I'm going to check more and try to narrow it down.

Include() and FirstOrNullEntity() : Hi JulianBenjamin, I was not...

Mon, 31 Jan 2011 12:42:03 -700

Author: sbelini
Subject: 2475
Posted: 31-Jan-2011 at 12:42pm

Hi JulianBenjamin,

I was not able to reproduce your issue.

Here's a simple test I ran against NorthwindIB:

public void TestInclude() {

var mgr = new IdeaBladeTest1Entities();

var query = mgr.Employees.Where(e => e.EmployeeID == 1).Include("Orders");

var employee = query.FirstOrNullEntity();

// all orders belonging to employee are loaded into cache

var orders = mgr.Orders.With(QueryStrategy.CacheOnly).Where(e => e.EmployeeID == 1).ToList();

}

Can you provide a simple solution (against NorthwindIB) reproducing your issue?

Regards,

Silvio.

Include() and FirstOrNullEntity() : When using the Include function,...

Sun, 30 Jan 2011 12:25:07 -700

Author: JulianBenjamin
Subject: 2475
Posted: 30-Jan-2011 at 12:25pm

When using the Include function, the FirstOrNullEntity doesn't fetch the included items; additionally, it seems it thinks it has queried for the related items, and so returns a nullentity for related entities even though removing the Include and then navigating the references triggers a query and returns the correct data.

Is this a bug? my code is as follows:

EntityQuery<b2b_product> query =

(EntityQuery<b2b_product>)

BusinessGlobals.b2bEntityManager.b2b_product.Where(p => p.item_number == ItemNumber).Include("as400_itemex01");

return query.FirstOrNullEntity();

I've also tried the suggestion from this thread (http://www.ideablade.com/forum/forum_posts.asp?TID=2430) and it's still not returning items.