nhibernate linq basics

Question

I need to transform this query to nhibernate linq

 IEnumerable<Account> accounts = from a in dc.Accounts
                                 where (a.FirstName + " " + a.LastName).Contains(SearchText) ||
                                        a.Email.Contains(SearchText) ||
                                        a.Username.Contains(SearchText)
                                 select a;

I tried with this but I"m stuck at the beginning so I need help.

IEnumerable<Account> accounts = NHSession.Query<Account>().Where(x=>x.FirstName)

'I need help' is not a question. If you asked a specific question you would get much more helpful answers. — Kendall Frey
– Kendall Frey, Commented Feb 24, 2013 at 2:29

Bill Berry · Accepted Answer · 2013-02-24 02:22:54Z

2

From the looks of your query you might want to spend a few min and read Ayende's post on Complex Searching found here.

Rather than using the Session Query or Detached Criteria - look into implementing this as a QueryOver. Then you can build the search criteria well ahead of the session call, then simply pass in the query to the session when you are finally ready to bring it up. Also don't forget Future Values and Paging for larger result sets:

answered Feb 24, 2013 at 2:22

Bill Berry

4334 silver badges13 bronze badges

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

Comments

tchrikch · Accepted Answer · 2013-02-23 23:58:23Z

1

Query below will return IQueryable<Account> , you can either use it for further querying or evaluate to obtain results.

var accounts = NHSession.Query<Account>().Where(a=> (a.FirstName+" "+a.LastName).Contains(SearchText) || a.Email.Contains(SearchText) || a.Username.Contains(SearchText) );

answered Feb 23, 2013 at 23:58

tchrikch

2,4681 gold badge23 silver badges43 bronze badges

Collectives™ on Stack Overflow

nhibernate linq basics

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related