NHibernate native sql query

Just one sentance if you query in the code: session.CreateSQLQuery("select u.Id as {user._id},u.Name as {user._name} from users u","user",typeof(User).List();

Attention:you must query all the mapping field, or you will get the "System.IndexOutOfRangeException",it had bothered me for the whole afternoon,so you don't do stupid like me.

On the other hand,you can also make the sql query in the mapping file if you didn't want to write any sql code in your data access layer.

 it looks like this: select u.Id as {user._id},u.Name as {user._name} from users u then you can use it in the data access layer: Session.GetNamedQuery("testQuery").List();

ok,finished.