Hi,

How can I select only a few columns from a table? Let's say I have the following map:

Table("Items");
Id(x => x.ItemId).GeneratedBy.GuidComb().UnsavedValue(Guid.Empty);
Map(x => x.Heading).Length(200).Not.LazyLoad();
Map(x => x.Introduction).Length(500).Not.LazyLoad();
Map(x => x.TimeCreated).Not.LazyLoad();

How can I use CreateCriteria to select only the heading and introduction of a specific item?

Thanks in advance.

Have a look at the SetProjection method on the criteria:

criteria.SetProjection(Projections.Property("propName"))

criteria.SetProjection(new ProjectionList()
.Add(Projections.Property("propName1")
.Add(Projections.Property("propName2")

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