Distinct Query in nhibernate

Question

I am new in nHibernate and i want to convert following sql query in nHibernate criteria

SELECT DISTINCT fReportID, fFiscalYear FROM tFCMaster WHERE fPropertyID='100'

I tried this:

Session.CreateCriteria<tFCMaster>().Add(Expression.Eq("fPropertyID", PropertyID)) .SetProjection(Projections.Distinct(Projections.Property("fFiscalYear"))) .List<tFCMaster>();

help will appreciated.

could you show is what you have tried, and why i didn't work — Jens Kloster
– Jens Kloster, Commented Oct 18, 2013 at 9:57
Session.CreateCriteria<tFCMaster>() .Add(Expression.Eq("fPropertyID", PropertyID)) .SetProjection(Projections.Distinct(Projections.Property("fFiscalYear"))) .List<tFCMaster>(); i tried this but it is giving error. — Tikam Sangwani
– Tikam Sangwani, Commented Oct 18, 2013 at 10:02
ok :) you should show that the error is by adding it to your question — Jens Kloster
– Jens Kloster, Commented Oct 18, 2013 at 10:41
if you want to map the result to tFcMaster, you have to include fPropertyID in your projection (assuming the table has exactly two columns) — jbl
– jbl, Commented Oct 18, 2013 at 12:17

Cássyo Kist · Accepted Answer · 2013-10-18 12:56:04Z

1

Try this one.

criteria.SetProjection(Projections.Distinct(Projections.Property("Country")));

Best Regards.

answered Oct 18, 2013 at 12:56

Cássyo Kist

111 bronze badge

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

Collectives™ on Stack Overflow

Distinct Query in nhibernate

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related