Since version 3.0 NHibernate has included a LINQ provider. In this recipe, we'll show you how to execute LINQ queries with NHibernate.
Add a new folder named
QueryByLinq
to the project.Add a new class named
LinqQueries
to the folder:using System.Collections.Generic; using System.Linq; using NH4CookbookHelpers.Queries; using NH4CookbookHelpers.Queries.Model; using NHibernate; using NHibernate.Linq; namespace QueryRecipes.QueryByLinq { public class LinqQueries : IQueries { private readonly ISession _session; public LinqQueries(ISession session) { _session = session; } public IEnumerable<Movie> GetMoviesDirectedBy( string directorName) { return _session.Query<Movie>() .Where(x => x.Director == directorName) .ToList(); } public IEnumerable<Movie> GetMoviesWith( string actorName...