ansaurus

Question

How to get this kind of query in NHibernate : SELECT DISTINCT FileName From CustomerFile WHERE name = ' ' AND timeframe = ''

Answer 1

+1 A:

Why not just use the custom SQL that you've sketched in, above, and map the result column to Strings? Why jump through ORM hoops to do something simple?

session
 .CreateSQLQuery("SELECT DISTINCT FileName From CustomerFile WHERE name = ' ' AND timeframe = ''")
 .AddScalar("FILENAME", NHibernateUtil.String)

Jonathan Feinberg 2009-10-15 15:47:31

Thanks, project's entire Dat aaccess logic is done with NHibernate, so I dont want to deviate it from it. Of course doing this with SQL server is really trivial task.

Shiva 2009-10-15 16:10:36

To get compile time integrity perhaps?

ssg 2009-10-15 16:24:39

It *is* still "done with NHibernate"! See https://www.hibernate.org/hib_docs/nhibernate/1.2/reference/en/html_single/#d0e8963

Jonathan Feinberg 2009-10-15 16:40:08

Thanks Jonathan for the hyperlink.

Shiva 2009-10-15 16:58:42

+1 for that hyperlink

Shiva 2009-10-15 16:59:17

ansaurus

tags:

views:

answers:

How to get this kind of query in NHibernate : SELECT DISTINCT FileName From CustomerFile WHERE name = ' ' AND timeframe = ''

related questions