I'm trying to do a projection with these two classes:
public class SomeClass
{
public virtual int Id { get; private set; }
public virtual string Name { get; set; }
public virtual IList<Language> Languages { get; set; }
}
public class Language
{
public virtual string Code { get; set; }
}
The mapping look like this:
public class SomeClassMapping : ClassMap<SomeClass>
{
public SomeClassMapping()
{
Id(x => x.Id).GeneratedBy.Identity();
Map(x => x.Name)
.Length(255)
.Not.Nullable();
HasMany(x => x.Languages)
.KeyColumn("SomeClassId")
.Table("SomeClassLanguages")
.Component(x => x.Map(y => y.Code))
.Cascade.All();
}
}
public class LanguageMapping : ComponentMap<Language>
{
public LanguageMapping()
{
Map(x => x.Code);
}
}
This is the class that should hold the result:
public class SomeClassListItem
{
public int Id { get; set; }
public string Name { get; set; }
public string Languages { get; set; }
}
Conceptually what I want to do is make the language codes into a comma separated list, it's express below in code:
var items = (from s in _session.Query<SomeClass>()
orderby s.Name
select new SomeClassListItem
{
Id = s.Id,
Name = s.Name,
Languages = s.Languages.Select(x => x.Code).Aggregate((current, language) => current + (language + ", "))
}).ToList();
Any suggestions on how to accomplish this with LINQ, HQL, ICriteria, or some other way?