[nhusers] Re: Joins

2009-08-10 Thread Oskar Berggren
If you need to merge data from several tables into one entity the statement might be for you. For collections you might instead want to look up using fetch mode join. /Oskar 2009/7/22 Sachin : > > I need to know that if I have to get data from multiple database > tables into one entity in my co

[nhusers] Re: joins

2009-08-06 Thread Stefan Steinegger
You can use the join element to map properties which are in another table. You could have more or less classes as tables. Usually, you have more classes then tables. This is because of performance optimization. Classes could be as small as needed to make them reusable, and you will have classes c

[nhusers] Re: Joins

2009-07-19 Thread Sachin
Thanks for the reply, So, if I have to fetch values from multiple tables then I have to create collections IList and fetch them using Bags and in case it is not a collection then I can add a reference and can fetch them by specifying Join type. But I want that instead of collections it should be

[nhusers] Re: Joins

2009-07-17 Thread Raul Carlomagno
you can get all your object's grpah in one hit using fetch load mode, or you can transform all your data into a dto using positional to bean transformer On Jul 17, 12:25 pm, Oskar Berggren wrote: > 2009/7/17 Sachin : > > > > > Hi > > How can I perform join between multiple tables as I need one e

[nhusers] Re: Joins

2009-07-17 Thread Oskar Berggren
2009/7/17 Sachin : > > Hi > How can I perform join between multiple tables as I need one entity in > my code which would be having data from multiple entities. Look up in the reference manual. Btw, I wouldn't call my database tables "entities". /Oskar --~--~-~--~~~