Quote Originally Posted by jmcilhinney View Post
It depends on the circumstances. If appropriate you might create another entity but, in this case, probably not. You'd either perform a single query and extract out the data from the result set for the two entities or else you'd perform two separate queries.
thnx jm,

the above scenario is just an example to explain my question. My environment is large. it has 50+ tables. 50+ entities. The reason I wanted to clear this doubt is to go on a standard way. I would have many joint query to execute if I want to proceed.

What I want to konw is the correct standard. I should create seperate DAL class and BLL class for where joint query needed or has to perform operation by normal query multiple times?