Hi,
In the past I used joined queries to generate "readable", updatable lists for users.
For instance:
not readable:
custID,EmpId1,EmpID2,CountryID,Address
1,2,3,2,Hoofdstraat
readable:
custName,EmpName,EmpName,Country,Address
Jansen,Piet,Klaas,Nederland,Hoofdstraat
the "readable" variety using a query like:
select c.custname,e1.empname,e2.empname.k.country, r.address from relation r
inner join customer c on c.id = r.custid
inner join employee e1 on e1.id = r.empid1
inner join employee e2 on e2.id = r.empid2
inner join country k on k.id = r.countryid
What's the best approach using LLBLGEN
1.Using prefetch and filling collections of CustomerEntities, EmployeeEntities,CountryEntities etc. So keep it all separated in their entities
2.Defining Views ( with joins ) in the database and let LLBLGEN create entities on those views ? So it's a kind of mixing of database entities using views
Leon
