Hi

I am new to NHibernate, I have created a maping file for all the columns in a table Customer this works and gives me all the vaues in the table.
But for a perticular case i need only the customerId of all the customer,
is there any way to retrive only this column using the same mapping file.

Thanks

Arvind

I think IQuery.Enumerable() is what you are searching for. I've never used it myself but the documentation says that it's returning a list of proxy objects.

You can use a projection either with HQL:

IQuery q = session.CreateQuery("select c.id from Customer c")

or with a criteria

ICriteria c = session.CreateCriteria(typeof(Customer),"c")
.SetProjection(Projections.Id());

Then either q.List<int>() or c.List<int>() returns a list of the ids.