public void ResultTransformer() { IDetachedQuery dq = new DetachedNamedQuery("NoFoo.SQL.Parameters"); dq.SetString("p1", "%1_") .SetResultTransformer(new AliasToBeanResultTransformer(typeof(NoFoo))); using (ISession s = OpenSession()) { IQuery q = dq.GetExecutableQuery(s); IList<NoFoo> l = q.List<NoFoo>(); Assert.AreEqual(5, l.Count); } }
public void ExecutableNamedQuery() { IDetachedQuery dq = new DetachedNamedQuery("Foo.WithParameters"); dq.SetString("pn", "N2"); using (ISession s = OpenSession()) { IQuery q = dq.GetExecutableQuery(s); IList<Foo> l = q.List<Foo>(); Assert.AreEqual(1, l.Count); Assert.AreEqual("N2", l[0].Name); Assert.AreEqual("D2", l[0].Description); } // reusing same IDetachedQuery dq.SetString("pn", "@All@"); using (ISession s = OpenSession()) { IQuery q = dq.GetExecutableQuery(s); IList l = q.List(); Assert.AreEqual(totalFoo, l.Count); } }