Hii to all, I am facing a problem with Searching Functionality. In this functionality I have only one TextBox for searching. Basically searching would apply with following criteria s or Keywords.
-Searching Can be Done with
1. Employee's First Name
2. Employee's Last Name
3. Branch
4.Designation
5.City
6.State
7.Date of Birth
8. Date of Joining

On running module,Only Employee First Name is the keyword which is being used to search a Employees

string SearchQuery = txtSearch.Text;

IList<Employees> foundEmployees = session.CreateCriteria(typeof(Employees)).Add(Expression.Like("FirstName", "%" + SearchQuery + "%")).List<Employees>();

But I want all the above Keywords and using them in above query

Hi!
I have exactly the same problem as you have.
did you find a solution to this problem?

Best Regards
Svante

I had the same problem. I'm using Criteria and have something like this:



This works but you can only add two Criterions. To compare more fields you can use Disjunction:



What I still don't get is how to add associated restrictions to a disjuction.



How would you throw this in the mix?