Selecting Columns

Posts   
 
    
skhnsb
User
Posts: 4
Joined: 15-Jun-2006
# Posted on: 15-Jun-2006 22:52:13   

Is it possible to select specific columns from a typed view, collection or entity? Queries like the following:

Select colA, colB FROM vwTest or Select colA, colB FROM tableA

Thanks.

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 16-Jun-2006 08:48:23   

If you want to select those colums at code-time, then you should use a dynamicList which select fields from available entities, so if you want to use it, you might also want to map you database views (from which you will select some fields) to entities using the LLBLGen Pro designer.

Else if you want you may select and limit the fields in an Entity, typedList and TypedView at design time, using the LLBLGen Pro designer.