Visual Basic

.chld3 = t.child3s.AsQueryable().Include(Function(t411) t411.Child3Itms).Where(Function(t41) t41.vl3 > 7)

System.NotSupportedException: 'LINQ to Entities does not recognize the method 'System.Linq.IQueryable`1[Myprog.Child3] Include[child3,ICollection`1](System.Linq.IQueryable`1[Myprog.Child3], System.Linq.Expressions.Expression`1[System.Func`2[Myprog.Child3,System.Collections.Generic.ICollection`1[Myprog.Child3itm]]])' method, and this method cannot be translated into a store expression.'

Dim lst = (From t In context.MasterTable.Where(Function(t1) t1.id = 7)
             Select New With {
                               t,
                               .chld1 = t.child1s.Where(Function(t21) t21.vl1 >5),
                               .chld2 = t.child2s.Where(Function(t31) t31.vl2>6 ),
                               .chld3 = t.child3s.Where(Function(t41) t41.vl3>7),
                               .chld3itms = t.child3s.Where(Function(t51) t51.vl3>7).Select(Function(t511) t511.Child3Itms)
                              }).ToList

Dim lst = (From t In context.MasterTable.Where(Function(t1) t1.id = 7)
              Select New With {
                           t,
                           .chld1 = t.child1s.Where(Function(t21) t21.vl1 >5),
                           .chld2 = t.child2s.Where(Function(t31) t31.vl2>6 ),
                           .chld3 = (From t2 in t.child3s.Where(Function(t41) t41.vl3>7) 
                                Select New With {
                                           t2,
                                           .chld3it=t2.Child3Itms   
                                                 })
                               }).ToList

Member 11220465 wrote:

"Conversion of a varchar data type to a datetime data type resulted in an out-of-range value"

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Member 11220465 wrote:

And again, excuse my grammar mistakes; I'm not a native speaker.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Member 14362033 wrote:

VBScript compilation error '800a0401' Expected end of statement