How to load only certain columns using fluentnhibernate?

Question

I want to know how I can fill only certain columns when filling an entity object?

I am interested in certain properties of the object and not all.

but when I use the session to retrieve the object, it sends a request, for example, "select * from Customer".

but I want to do "Select customerName from customer."

I think this has something to do with LazyLoad (), but I don’t know exactly how.

Any help would be greatly appreciated.

Thanks Advance, Ashish

Answer 1

var defs = session.CreateCriteria(typeof(test));
defs.SetProjection(Projections.ProjectionList()
    .Add(Projections.Property("FirstColumn"));