public void can_use_aggregate_function_and_project_into_entity()
{
using (var session = factory.OpenSession())
{
var countOfNameView = session.CreateQueryFor <Department>()
.Select(SelectionOptions.CountOnFieldFrom <Department>(d => d.Name, "name_count"))
//.JoinOn<Instructor>(i=>i.Department.Id, d=>d.Id)
.CreateCriteria(Restrictions.Like <Department>(d => d.Name, "arts"))
.SingleOrDefault <CountOfNameView>();
Assert.NotNull(countOfNameView);
Assert.Equal(1, countOfNameView.Count);
}
}
