I have to write a query in Fluent NHibernate for
Select * from Users where UserName = 'Abcd' AND Password = '123456'
How to create above query with session.CreateCriteria
Fluent NHibernate Where Clause
Viewed 17720
3 Answers
If you are using IQuery:
User user = new User();
user.username="Abcd";
user.password="123456";
IQuery q = session.CreateQuery("from foo in class Foo where
user.username=:username and user.password=:password");
q.SetProperties(user);
var users= q.List<User>();
Related