hi,

i have a table for my groups in the db (tbl_dbtool_group). this table have an id field which is primary key...therefor i have an Group.cs Class in my Code...

the following query does not work in my code:



i became back the hole table data...what is wrong there??

thX
yesso

I tried a similar example in Java and noticed I had to alias the source class. So instead of what you have:

"select max(Group.Id) from Group"

You'd need:

"select max(g.Id) from Group g"

And I suspect you should also be using UniqueResult() instead of List().

thank u very much;)

i have read again the docu and saw that the select needs the alias...

thx
yesso