Here is my question
In my application, I have a entity which stores Locations
Each Location will have one Organizational Unit and Organizational Unit have users
When the user logs in, I should be able to get all the location he is belongs to and I should restrict only the data relates to the Locations.
How to do that ?
You can load user's locations and store them into a cache (<a class="postlink" href="http://www.aspnetboilerplate.com/Pages/Documents/Caching">http://www.aspnetboilerplate.com/Pages/ ... ts/Caching</a>) and use it in your further queries by getting from cache.
You can also see query examples to retrieve locations of users: <a class="postlink" href="http://www.aspnetboilerplate.com/Pages/Documents/Zero/Organization-Units#common-use-cases">http://www.aspnetboilerplate.com/Pages/ ... -use-cases</a>
Have a nice day.