Hi guys, I have an application written in .Net using Nhibernate for retrieving data about symphony performances, the main tables are

Event - Description of something, e.g. Beethoven

performance - the date the event will be played on, there are many performances of an event, this also has a M:M to the artist table :

Artists - this is the name of the performer of the performance, there will be many artists per performance and many artists across performances.

I have to do a web engine style search so that if some said

"spano june beethoven"

I'd need to search the performance name and description tables for each of those words (spano is a conductor who could be mentioned in the description of the event, or the name of an artist). I'd then need to figure out that june is month 6 and search performances that occur in june. I'd also need to then search the description of the event for beethoven and the artists table for beethoven.

Do I abandon Nhibernate for this type of query and just use ADO and some basic queries or is there some tutorial or paper that can help me figure this out. I have not looked at the SQL server docs yet to see if they have any helper prioprietary functions I can use for date searches using keywords.

Thanks
Grant Davies
Bluetube Interactive
http://www.bluetube.com/bti/index.html