i want to pick a specific column from the DataBase table "department" , the column name is
'DeptName' working with HQL in Nhibernate


public IList<CMM_Dept_Info> GetAllDeptNames()
{
ICriteria criteria = Session.CreateCriteria<CMM_Dept_Info>("SELECT Dept_Name FROM CMM_Dept_Info");

return criteria.List<CMM_Dept_Info>();
}



this returns the Primary key column while i need the DeptNAme column that is ,the names


Please help

Criterias do not work with SQL. Do you mean session.CreateQuery ?

ok

how can i do this ??
i mean i want to pick a field "DeptName" from the table "DEpt_Info"

dept_name is not a primary key field

public IList<CMM_Dept_Info> GetAllDeptNames()
{
Session.CreateQuery("SELECT di.Dept_Name FROM CMM_Dept_Info di");
return criteria.List<string>();
}

Thank GOD
done man :D

public IList<CMM_Dept_Info> GetAllDeptNames()
{
ICriteria criteria = Session.CreateCriteria<CMM_Dept_Info>();
Session.CreateQuery("SELECT di.DeptName FROM CMM_Dept_Info di");
return criteria.List<CMM_Dept_Info>();
}


Thanks to u too

Can u please tell me the difference between IQuery and HQL ?

There's non IQuery = HQL. ICriteria is different.

Query/HBM
http://nhforge.org/doc/nh/en/index.html#queryhql

Criteria
http://nhforge.org/doc/nh/en/index.html#querycriteria