The HQL I gave is HQL, not SQL, though the difference is barely noticeable in such a simple scenario. That's why it says "from User", instead of "from users" as you originally had.
Regarding the LINQ version, the select part will be included in the generated SQL query. It will NOT load all columns from the DB. /Oskar 2012/10/29 Micke <[email protected]> > Hi Oskar, > > if iam wrong please correct me - > > yes i can use native sql as HQL, but then i loose all the pro's of mapped > entities and hence of NH, dont i ? > with Linq i first have to pull all the data into the client where is start > the select, so i loose the pro's of execution at the DB / Server. > > kind regards > Micke > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/nhusers/-/HabIjJLe8xoJ. > > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
