NHibernate native sql query

最新推荐文章于 2021-06-10 08:42:30 发布

diaosu1177

最新推荐文章于 2021-06-10 08:42:30 发布

阅读量84

点赞数

原文链接：http://www.cnblogs.com/GodSpeed/archive/2009/03/27/1422812.html

版权

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.

转载于:https://www.cnblogs.com/GodSpeed/archive/2009/03/27/1422812.html