DevForce Community Forum : Filtered Includes

Filtered Includes : Hi Paul,Sorry for the delay.I...

Tue, 10 Apr 2012 10:49:21 -700

Author: sbelini
Subject: 3379
Posted: 10-Apr-2012 at 10:49am

Hi Paul,

Sorry for the delay.

I moved your last question to the Cocktail forum.

Silvio.

Filtered Includes : Any input from anyone? Should...

Mon, 09 Apr 2012 18:23:54 -700

Author: paul
Subject: 3379
Posted: 09-Apr-2012 at 6:23pm

Any input from anyone? Should I cross-post to the Cocktail forum. I didn't want it to get lost after the holiday weekend. Thanks...

Filtered Includes : Hi Paul,Unfortunatelly, you...

Fri, 06 Apr 2012 08:25:12 -700

Author: sbelini
Subject: 3379
Posted: 06-Apr-2012 at 8:25am

Hi Paul,

Unfortunatelly, you won't be able to filter entities retrieved via Include.

However, a workaroud would be using select:

var employees = Manager.Employees.Where(e => e.EmployeeId == employeeId)

.Include(e => e.Person)

.Include(e => e.Person.Address)

.Include(e => e.Person.Address.Region)

.Select(e => new { Employee = e,

RegionLocalizeds = e.Person.Address.Region.RegionLocalizeds.Where(rl => rl.LanguageTypeId == CurrentLanguageTypeId))

.ToList()

.Select(emp => emp.Employee;

There is a forum post at http://www.ideablade.com/forum/forum_posts.asp?TID=2097&PID=8208#8208 that address the same issue.

Regards,

Silvio.

Filtered Includes : I know it isn't possible...

Thu, 05 Apr 2012 20:26:19 -700

Author: paul
Subject: 3379
Posted: 05-Apr-2012 at 8:26pm

I know it isn't possible with EF right now but I was curious what other people have done. This is what my ideal code looks like but since EF doesn't support filtered includes it won't work.

IEntityQuery query = Manager

.Employees

.Where(e => e.EmployeeId == employeeId)

.Include(e => e.Person)

.Include(e => e.Person.Address)

.Include(e => e.Person.Address.Region)

.Include(e => e.Person.Address.Region.RegionLocalizeds.Where(rl => rl.LanguageTypeId == CurrentLanguageTypeId));