TypedList or TypedView, that is the question

Posts   
 
    
Answer
User
Posts: 363
Joined: 28-Jun-2004
# Posted on: 10-Mar-2006 16:58:28   

I was wondering when you guys use what?

I have a manufacture table that has two FK that link to the state name, and the country name, and for display purposes (list of the manufactures and there locations) im not sure i should use a typedlist or a typedview?

What criteria do you guys use when determining whether to create a view in the DB, or just you a typedlist?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39930
Joined: 17-Aug-2003
# Posted on: 11-Mar-2006 10:04:24   

Typically a maintenance problem I think: a view is stored in the DB, and therefore requires a DBA to get it changed, a typedlist can be created in the designer and doesn't require a DBA. The typedlist requires a very small amount of overhead (generating a join query) while the view doesn't.

Frans Bouma | Lead developer LLBLGen Pro