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();
}
Bug
Major
