llblgen 2.6
dotnet 3.5
sqlserver 2005
I have the following tables:
order - order_status m:1
I have the following fields-mapped-on-related-fields:
order.orderstatusdescription is mapped to orderstatus.description.
I would like to fetch an order entity that does have the orderstatusdescription field filled out except I don't want to have the order.order_status filled out. I want this due to 2 reasons:
- having order.order_status filled out result in 2 queries in SQL. One is query for order join order_status and one is query for order_status. This creates unnecessary extra query.
- the order.order_status instance consume extra memory unnecessarily.
Thanks
BZ