Loading a 1:M typed view

Posts   
 
    
hchattaway
User
Posts: 38
Joined: 06-Apr-2006
# Posted on: 14-Jan-2018 20:14:46   

Hello! I haven't used this in quite a while.. my company is using EF and it has not been a great experience... one thing I forget here is I defined a Typed View between 2 tables with a 1:M... Should the M side get loaded when calling FetchTypedList() should that load up the M side of the relationship also so I can traverse it for each record in the 1 side?

Thanks! Harold

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 15-Jan-2018 08:10:56   

Hi Harold,

A TypedList is a flat structure which contains the fields you defined in the designer. Those fields may be part of different entities. At runtime when you fetch the TypedList, it will load all the involved tables and fields and it will fill a flat Table with the result. So the result is flat, you can't traverse the levels, if you want that you should try with normal entities, or DTOs.

David Elizondo | LLBLGen Support Team