代码从32位系统转移到64位系统SetMaxResults分页报错,请教高手怎么回事?
报错信息:could not execute query [ select TOP (@p0) userrole0_.RoleID as RoleID13_, userrole0_.RoleName as RoleName13_, userrole0_.Description as Descript3_13_ from UserRole userrole0_ ] [SQL: select TOP (@p0) userrole0_.RoleID as RoleID13_, userrole0_.RoleName as RoleName13_, userrole0_.Description as Descript3_13_ from UserRole userrole0_]链接方言:
<add key="db.provider" value="SqlServer-2.0" />
<add key="db.connectionString" value="Server=(local);database=Assure;uid=sa;pwd=123" />
<add key="db.driver_class" value="NHibernate.Driver.SqlClientDriver" />
<add key="db.dialect" value="NHibernate.Dialect.MsSql2008Dialect" />
就是这一句:IList<T> list = query.SetFirstResult(Start).SetMaxResults(Max).List<T>();
去掉分页就没有问题了
补充:.NET技术 , .NET Framework