有时候Query太复杂时,使用NHibernate的Query会组到疯掉,又不想用System.Data.SqlClient时,就可以用用NHibernate的SQLQuery,它可以直接输入普通的Query,不过在输出的资料型态上,需要指定成NHibernate的
类型,不然会吐出错误讯息:
NHibernate.QueryException : Return types of SQL query were not specified
举例如下:
NHibernate.QueryException : Return types of SQL query were not specified
举例如下:
1
ZhuJi.Modules.CountModule.Domain.CountHour domainCountHour
=
new
ZhuJi.Modules.CountModule.Domain.CountHour();
2 hql = string .Format( " Select Top 1 * From CountHour as tmp Where tmp.Ip Like '{0}' And DATEDIFF(d,tmp.Addtime,'{1}')=0 " , ip, addTime);
3 ISQLQuery sqlQuery = session.CreateSQLQuery(hql);
4 sqlQuery.AddScalar( " Id " , NHibernateUtil.Int32);
5 sqlQuery.AddScalar( " Ip " , NHibernateUtil.String);
6 sqlQuery.AddScalar( " Pvs " , NHibernateUtil.Int32);
7 sqlQuery.AddScalar( " Ips " , NHibernateUtil.Int32);
8 sqlQuery.AddScalar( " Cookies " , NHibernateUtil.Int32);
9 sqlQuery.AddScalar( " AddTime " , NHibernateUtil.DateTime);
10 IList < ZhuJi.Modules.CountModule.Domain.CountHour > listCountHour = sqlQuery.List < ZhuJi.Modules.CountModule.Domain.CountHour > ();
2 hql = string .Format( " Select Top 1 * From CountHour as tmp Where tmp.Ip Like '{0}' And DATEDIFF(d,tmp.Addtime,'{1}')=0 " , ip, addTime);
3 ISQLQuery sqlQuery = session.CreateSQLQuery(hql);
4 sqlQuery.AddScalar( " Id " , NHibernateUtil.Int32);
5 sqlQuery.AddScalar( " Ip " , NHibernateUtil.String);
6 sqlQuery.AddScalar( " Pvs " , NHibernateUtil.Int32);
7 sqlQuery.AddScalar( " Ips " , NHibernateUtil.Int32);
8 sqlQuery.AddScalar( " Cookies " , NHibernateUtil.Int32);
9 sqlQuery.AddScalar( " AddTime " , NHibernateUtil.DateTime);
10 IList < ZhuJi.Modules.CountModule.Domain.CountHour > listCountHour = sqlQuery.List < ZhuJi.Modules.CountModule.Domain.CountHour > ();