CODEWITHSUNDEEP
fluent-nhibernate
Ashish
Ashish

Reputation: 437

How to load only certain columns using fluentnhibernate?

I want to know how can i fill only certain columns while filling the entity object?

i am interested in certain properties of the entity and not all.

but when i use session to fetch the entity it sends query like "select * from Customer" for example.

but i want to do "Select customerName from Customer".

I think it has some thing to do with LazyLoad() but i am not sure how exactly.

Any help will be highly appriciated.

Thanks in Advance, Ashish

Upvotes: 3

Views: 735

Answers (1)

Matthew Talbert
Matthew Talbert

Reputation: 6048

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

Upvotes: 2

Related Questions