New to NHibernate so please be patient. This might be something really simple..

I have a named sql-query in my mapping file (SummaryObject). It runs fine but the results are the same object. Note, the record count is correct.

I think the problem is because I am returning 0 for my ID but I have to since the query is actually quering different (details) tables that eventually will be inserted into my summaryObject. If I leave out the ID from the query I get an error.

Any suggestions?

You definetely need some king of id. Otherwise hibernate can't distinguish the objects. If you don't have on in your query try to use a surrogate id, e.g ROW_NUMBER() or a combination of some columns which are unique. But have in mind that using ROW_NUMBER() might not be repeatable in the assigned ids.

But it's hard to give you more advice without knowing more about the objects and the query.