Entity Framework : Filter child entities

Former Member — Sat, 31 Jan 2015 17:03:20 GMT

Hello !

I'm using VB.net and entity Framework. I have situation where depending on several conditions I construct a query step by step .

This is the code :(Article has 2 relationship with F1 and F2)

Dim list1 As IEnumerable(Of Article)
     list1 = From t In context.Articles.Include("F1").Include("F2") Order By t.name Ascending
                 Select t
     If condition1 then
         list1 = list1.Where(Function(t2) t2.tp = 1)
     End If
     If condition2 then
         list1 = list1.Where(Function(t2) t2.id = 7)
     End If
     Myreport.datasource=list1.ToList()


This code is working , but now I want to add a new condition , and if this is true the child "F1" should be filtered.
How can I filter the Child "F1" 
Thank you !

Re: Entity Framework : Filter child entities

VolkerBarth — Mon, 02 Feb 2015 05:04:58 GMT

This seems to be basically an EF question. Is that question related to SQL Anywhere (except the fact that one can use EF with SQL Anywhere)?

Question Re: Entity Framework : Filter child entities in Technology Q&A

Entity Framework : Filter child entities

Re: Entity Framework : Filter child entities