Using CriteriaQueries

In the last chapter, we fetched our entities by their Id. In this recipe, we'll show you a few basic criteria queries to fetch entities by other properties.

Getting ready

Complete the Getting Ready section at the beginning of this chapter.

How to do it…

1. Add a new folder named QueryByCriteria to the project.

2. Add a new class CriteriaQueries to the folder:

   using System.Collections.Generic;
   using NH4CookbookHelpers.Queries;
   using NH4CookbookHelpers.Queries.Model;
   using NHibernate;
   using NHibernate.Criterion;
   using NHibernate.SqlCommand;
   
   namespace QueryRecipes.QueryByCriteria
   {
       public class CriteriaQueries : IQueries
       {
           private readonly ISession _session;
   
           public CriteriaQueries(ISession session)
           {
               _session = session;
           }
   
           public IEnumerable<Movie> 
   GetMoviesDirectedBy(string directorName)
           {
               return _session.CreateCriteria<Movie>()
                 .Add(Restrictions.Eq("Director", 
            ...