Hi,
i'm building a DAL in C# that is connecting to an ancient versione of informix, so i cannot use entity framework. I wrote the entities classes referencing them self in a parent-child fashion. now i wrote the DAL classes one for each entities implementing generic methods such as getbyid(object key),findall() ... now the question is for loading child entities on demand. I'm implementing methods in this Way : OrderDAL.LoadRows() (binding OrderRows to the given order)m Customer.LoadContacts() etc.. do you think is a good idea ? it seems to work at a first look, but i'm scared for when the project will become more complex ( thinking to scalability and maintenance issues). Any help, link or something else will be appreciated.
thx Giuliano