Whereas the NH code base now includes preliminary support for generics, I decided to try to switch my project from using WilsonORMapper to NH. One of the things I'm missing from WORM is the GetDataSet method.

I have several views in my app that display a limited set of properties from a set of entities. I can craft a query very easily that will only "select" the properties I need in the view, but the format of the returned results (a list of arrays) I am finding difficult to deal with.

Am I overlooking something that will work as well or better than what I'm asking for?

Thanks,
Daniel

http://www.hibernate.org/hib_docs/nhibernate/html/mapping.html#mapping-declaration-import
http://www.hibernate.org/hib_docs/nhibernate/html/queryhql.html#queryhql-select

You can create a class of just the properties you want, import it in the mapping, then HQL like:

You will get back a collection of FooLite objects instead of an object[]*. This can be bound using databinding.

That's pretty good, k-dub. I guess the only significant drawback is that the set of properties that can be returned is rigid. In other words, it won't be practical to allow the user to select visible columns from all possible properties and then dynamically construct a query.

The other option that I am considering is using a hybrid NH/ADO.Net approach. I wanted to be pure NH, but I may have to sacrifice.

Thanks for the help.

Regards,
Daniel