This question is locked. New answers and comments are not allowed.
Hello all,
I'm new to OpenAccess and trying to use this tool in one of my projects. I'm generated my domain using the reverse mapping and all is great. I need to if there is a way to restrict the records fetched based on a condition. For example, I have Customer and Orders classes (domain) and the Customer class contains an IList of Orders indicating the Orders belonging to that Customer. I'm trying to see when I fetch the customers, only the orders that were placed in the last 6 months are fetched with it. The reason being as the database grows (in terms of orders for each customer), I do not want to fetch all the orders and then filter them out in the business layer rather restrict my fetch itself.
Any pointers/help to accomplish this.
Thanks
I'm new to OpenAccess and trying to use this tool in one of my projects. I'm generated my domain using the reverse mapping and all is great. I need to if there is a way to restrict the records fetched based on a condition. For example, I have Customer and Orders classes (domain) and the Customer class contains an IList of Orders indicating the Orders belonging to that Customer. I'm trying to see when I fetch the customers, only the orders that were placed in the last 6 months are fetched with it. The reason being as the database grows (in terms of orders for each customer), I do not want to fetch all the orders and then filter them out in the business layer rather restrict my fetch itself.
Any pointers/help to accomplish this.
Thanks