I am having problems trying to use the CreateSqlQuery method.

The error I am getting is:

[NHibernate.MappingException] = {"Invalid mapping information specified for type SchoolAdministration.Business.Student, check your mapping file for property type mismatches"}

InnerException = {"Unable to cast object of type 'CProxyTypeSchoolAdministration_BusinessStudentClassBusiness_NHibernate_ProxyINHibernateProxy1' to type 'System.Collections.Generic.IList`1[SchoolAdministration.Business.StudentClass]'."}

Here is what I am trying:

string q = @"SELECT {c.*}, {s.*}, {sc.*}
FROM Student s
inner join StudentClasses sc on s.id = sc.StudentId
inner join Class c on sc.ClassId=c.Id
WHERE s.Id=:StudentId and sc.SchoolYearId = :SchoolYearId";

IQuery query = session.CreateSQLQuery(q).AddEntity("s", typeof(Student))
.AddEntity("sc", typeof(StudentClass))
.AddEntity("c", typeof(Class))
.AddJoin("c", "s.Classes"); //s.Classes is a List<StudentClass>

query.SetParameter("StudentId", "1");
query.SetParameter("SchoolYearId", "2");

List<Student> ss = query.List<Student>() as List<Student>;

Here is my hbm file:
<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-access="property">
<class name ="SchoolAdministration.Business.Class, SchoolTest" table="Class">
<id name="Id" column="Id" type="int">
<generator class="native"/>
</id>
<property name="Name" column="Name" type="string"/>
</class>

<class name ="SchoolAdministration.Business.SchoolYear, SchoolTest"
table="SchoolYear">
<id name="Id" column="Id">
<generator class="native"/>
</id>
<property name="Year" column="Year"/>
<property name="Notes" column="Notes"/>
</class>

<class name ="SchoolAdministration.Business.StudentClass, SchoolTest"
table="StudentClass">
<id name="Id" column="Id">
<generator class="native"/>
</id>
<one-to-one name ="Student" class ="SchoolAdministration.Business.Student, SchoolTest"/>
<one-to-one name ="Class" class ="SchoolAdministration.Business.Class, SchoolTest"/>
<one-to-one name ="Year" class ="SchoolAdministration.Business.SchoolYear, SchoolTest"/>
<!--<property name="Grade" column="Grade"/>-->
</class>

<class name ="SchoolAdministration.Business.Student, SchoolTest" table="Student">
<id name="Id" column="Id" unsaved-value="-1" type="int">
<generator class="native"/>
</id>
<many-to-one class="SchoolAdministration.Business.StudentClass, SchoolTest"
column="Id" fetch ="join" name="Classes"/>
<property name ="Name" column ="Name" type="string"/>
</class>
</hibernate-mapping>



Can someone help me please.

I've got the error on SQL Server 2005+, however the same code works fine on SQL Server 2K.

Any chance you've solved the problem?

I don't know what your concrete problem is, but the query in the original post:

string q = @"SELECT {c.*}, {s.*}, {sc.*} ...

returns an array for each row containing a Class object, a Student object and a list of StudenClass. That's the reason why query.List<Student>() isn't working.

Post your query, otherwise it's hard to tell what's going wrong.

Thanks for the promp reply.
In my case there is no explicit query. I have two connected entities.


I got next error when I was trying to traverse ServiceGroup.Services:

System.InvalidCastException: Unable to cast object of type 'CProxyTypesampai_ProductBaseServiceProduct_NHibernate_ProxyINHibernateProxy_System_Runtime_SerializationISerializable2' to type 'Service'.
In debugger I saw that some objects of the collection were of the right type, but some was of the type noticed in the exception message.

The problem appears on SQL Server 2005, 2008 while on SQL 2K works fine.

Suppose that's your problem:

http://nhforge.org/doc/nh/en/index.html#performance-fetching-proxies

yes, that's definitely my case.

Thank you!