Hi,
I need to get values from multiple tables into a Custom data structure.
Example:
Table 1: ID, Name
Table 2: ID, Location
Table3: ID, Brand

My class looks like:


The class Data does not belong to any table. It is just a Data class that I would like to use in my application.
Can I achieve this functionality using NHibernate? If so, can someone give me an example mapping file?

Thanks,
Javid
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

NHibernate works with entities. So if you dont have actual domain entities to work with then you'll be better off using ado.net directly.

If you have domain entities that contain relationships to the type of data you are talking about you can place values from entities into custom data structures with the import statement and a query:

Import:


Query:


With the import strategy you will neeed exsiting entities though.

Are the Names, Locations and Brands stored in the database? Are they being handled by NHibernate?

If so, then in sounds like you just want to have a lookup list that you hold on to and can use whenver you need it. Is that right?

From my experience, this sounds like a bad idea. I'm no expert on sessions, but it seems like you could get into session issues by loading those lists early and leaving them around. You would need to either leave the session open, or you would need to reconnect them? (Maybe someone can comment on the accuracy of this statement?)

Anyways, in my WinForms application, when I need to provide a list of choices, I populate an IList in the form itself. The form has its own session. When I'm done with the form, the IList goes away, too.

You can fill the IList with HQL. That is what I do. Here's a basic example of an HQL search;

Thanks Pelton:
I understand what you meant.

Javid