Exception: System.Data.SqlClient.SqlException: Must declare the scalar variable "@p3".

Exception appears during select with paging when we using Projections with parameters in ordering

run the test below from CriteriaQueryTest fixture:

Test
public void IncorrectNumberOfCommandParametersTest()

{ ISession session = OpenSession(); ITransaction t = session.BeginTransaction(); Course courseA = new Course(); courseA.CourseCode = "HIB-A"; courseA.Description = "Hibernate Training A"; session.Save(courseA); Student gavin = new Student(); gavin.Name = "Gavin King"; gavin.StudentNumber = 232; gavin.PreferredCourse = courseA; session.Save(gavin); Student leonardo = new Student(); leonardo.Name = "Leonardo Quijano"; leonardo.StudentNumber = 233; leonardo.PreferredCourse = courseA; session.Save(leonardo); Student johnDoe = new Student(); johnDoe.Name = "John Doe"; johnDoe.StudentNumber = 235; johnDoe.PreferredCourse = null; session.Save(johnDoe); IProjection conditional = Projections.Conditional(Restrictions.Eq("Name", "Gavin King"), Projections.Constant("Eq Name"), Projections.Constant("AnotherName")); ICriteria criteria = session.CreateCriteria(typeof(Student)); criteria.SetMaxResults(1); criteria.SetFirstResult(1); IList result = criteria.SetProjection(Projections.Alias(conditional, "CheckName")) .AddOrder(Order.Asc("CheckName")) .List(); session.Delete(gavin); session.Delete(leonardo); session.Delete(johnDoe); session.Delete(courseA); t.Commit(); session.Close(); }