Im new in NHibernate, can any help me. I wast trying to retrieve the data thru CreateQuery and this error appears...

NHibernate.QueryException: in expected: <end-of-text> (possibly an invalid or unmapped class name was used in the query) [Select accountid, name, model from camera]

This is the code:

ISession session = DataAccessHelper.OpenSession();
IList ILCamera = session.CreateQuery("Select accountid, name, model from camera").List();

grdCamera.DataSource = ILCamera;

Camera is the table from MySQL server database. All I need is 3 fields from the table and even I put all the fields from the query statement, it causes the same error..



Plz.. Help...

Post your mappings and classes please.

Remember that HQL is case sensitive for your custom entitites. Be sure 'camera' is the name of your class and not 'Camera'
MIKE