Though there is only a little difference in simple queries, It has a impact on the complex query with a where clause and XMLType fields. So is there any way of using this feature through LLBLGen?
What's the advantage of using this, rather than manually caching the resultsets you need.
Isn't it beter to build you r caching logic in the BL rather then the DAL, which would make it tightly coupled with the database in hand.
Added to that, from the article, I understand there's no need for code in the client to use this. Only if you use manual mode, it requires hints in the SQL query, which isn't possible at this point.
