If I just want to keep things very simple, and just map my tables to POCO 1:1 with no collections on the entities
e.g. instead of doing :
class Order
class OrderItems
where you have:
Order o = new Order();
o.Items <-- collection of OrderItems that will query the db using lazy loading
I just have to do this manually:
Order o = myDAO.FindById(1);
OrderItems i = myDAO2.FindByOrderId(o.Id);
using this approach, do I still need to use castle.dynamic proxy dll and have to work around the medium trust issue?