Hi Marcello - the Criteria API is you friend here. A good example by Ayende is found here: http://ayende.com/Blog/archive/2006/12/07/ComplexSearchingQueryingWit...
Cheers, Thomas On 1 Jul., 22:04, supix <[email protected]> wrote: > Hi all. > > I'm facing the issue of providing the user of my applications with > easy-to-use search forms. In my mind, a search form is structured as a > grid whose columns are the "most important properties" of an entity, > those to be searched in. > > Without NHibernate I created a function implementing the "Search > Service", this way: > > int ok = Search(Connection, TableName, VisibleFieldsList, > IndexFieldName, SortedFieldName, WinCaption, ref IndexValue); > > The function shows a grid directly bound to a DBSource and populated > with data retrieved by an sql statement, dynamically created starting > from Search() input data. The user, while searching for a row, can re- > sort records, filter by any column, etc... interacting with the grid > (so triggering changes in the original sql statement --- expecially > the where condition and the order-by clause). > > Though strongly bound to all-the-DB-stuff, this approach has the great > advantage of allowing an easy search on virtually any table in my DB, > without developing anything. > > Is there some cots component implementing the NHibernate counterpart > for such a search form? > If not, how do you approach this problem in your applications? > > Thanx a lot, > Marcello. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
