using QueryOver's query separated

Question

How can I use QueryOver's linq query separated like below ICriteria which will be used in a generic method?

ICriterion c = Restrictions.And(Restrictions.Eq("Name", "Foo"),
     Restrictions.Or(Restrictions.Gt("Age", 21), Restrictions.Eq("HasCar",true)));

    IQueryOver<Foo> c = session.QueryOver<Foo>().Where((k => k.Name == "Tiddles" 
                  && k => k.Age== 21) || k => k.Age < 21);

    public static IList<T> All(ICriterion c)
    {
        using (var session = NHibernateHelper<T>.OpenSession())
        {
            var CC = session.CreateCriteria(typeof(T));
            CC.Add(c);
            return CC.List<T>();
        }
    }

Can you be a little more clear about what you're trying to accomplish? — Andrew Whitaker
– Andrew Whitaker, Commented May 21, 2015 at 16:48

xanatos · Accepted Answer · 2015-05-21 18:52:57Z

1

The equivalent to the first line, in lambda form is

ICriterion cr = Restrictions.Where<Foo>(k => k.Name == "Foo" && (k.Age > 21 || k.HasCar));

answered May 21, 2015 at 18:52

xanatos

112k13 gold badges209 silver badges297 bronze badges

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

Comments

dotjoe · Accepted Answer · 2015-05-21 18:46:51Z

1

You could pass in a Expression<Func<T, bool>> which is what one of the Where overloads accepts instead of a Criteria.

System.Linq.Expressions.Expression<Func<Foo, bool>> c = k => 
    (k.Name == "Tiddles" &&  k.Age== 21) || k.Age < 21;

public static IList<T> All(Expression<Func<T, bool>> expression)
{
    using (var session = NHibernateHelper<T>.OpenSession())
    {
        return session.QueryOver<T>()
            .Where(expression)
            .List();
    }
}

answered May 21, 2015 at 18:46

dotjoe

27.1k5 gold badges67 silver badges78 bronze badges

Collectives™ on Stack Overflow

using QueryOver's query separated

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