How use QueryOver on NHibernate to select custom result

Question

I have this code to return all colors with have some text:

public IEnumerable<Color> FindStartingWith(string term)
{           
    return Session.QueryOver<Color>().Where(color => color.Name.IsLike(text, MatchMode.Anywhere)).List();           
}

But what I want to do, is return a STRING IEnumerable containing only a list of color.Name...

How can I do that with QueryOver?

Thanks

Junio

Cole W · Accepted Answer · 2013-02-19 12:46:59Z

7

Syntax may not be exactly right but should be somethign like:

public IEnumerable<string> FindStartingWith(string term)
{           
    return Session.QueryOver<Color>()
                  .Select(color => color.Name)
                  .Where(color => color.Name.IsLike(text, MatchMode.Anywhere))
                  .List<string>();           
}

edited Feb 19, 2013 at 12:46

answered Apr 29, 2011 at 17:50

Cole W

15.4k7 gold badges56 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How use QueryOver on NHibernate to select custom result

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related