Linq query or plain SQL? On using tools for what they are made for.

There are some scenarios where using NHibernate.Linq makes no sense. NHibernate's provider is just a tool, with its design, its features and its limitations. It's important to be aware what each tool is the best at and not to look for universal tool.