NHibernate常见错误.docxVIP

NHibernate常见错误NHibernateSample.Data.Test.QueryHQLFixture.WhereTest:NHibernate.Hql.Ast.ANTLR.QuerySyntaxException : 引发类型为“Antlr.Runtime.NoViableAltException”的异常。near line 1, column 7 [select from ??NHibernateSample.Domain.Entities.Customer c where c.Firstname=scenery]?错误语法：select ?from customer正确语法：from customer?NHibernateSample.Data.Test.QueryOrderFixture.UseSQL_GetCustomersWithOrdersTest:NHibernate.Exceptions.GenericADOException : could not execute query[ select distinct customer.* from Customer customer inner join [Order] o on o.CustomerId=customer.CustomerId where o.OrderDate @p0 ]? Name:orderDate - Value:2011-9-5 0:00:00[SQL: select distinct customer.* from Customer customer inner join [Order] o on o.CustomerId=customer.CustomerId where o.OrderDate @p0]? ---- System.IndexOutOfRangeException : CustomerId0_0_?错误写法：return _session.CreateSQLQuery(select distinct {customer}.* from Customer {customer} +??????????? inner join [Order] o on o.CustomerId={customer}.CustomerId where o.OrderDate :orderDate)??????????????? .AddEntity(customer, typeof(Customer))??????????????? .SetDateTime(orderDate, orderDate)??????????????? .ListCustomer();正解写法：return _session.CreateSQLQuery(select distinct {customer.*} from Customer {customer} +??????????? inner join [Order] o on o.CustomerId={customer}.CustomerId where o.OrderDate :orderDate)??????????????? .AddEntity(customer, typeof(Customer))??????????????? .SetDateTime(orderDate, orderDate)??????????????? .ListCustomer();?NHibernateSample.Data.Test.ManyToManyFixture.UseCriteriaAPI_GetCustomerswithOrdersHavingProductTest: NHibernate.Exceptions.GenericADOException : could not execute query[ SELECT this_.CustomerId as CustomerId0_2_, this_.Version as Version0_2_, this_.Firstname as Firstname0_2_, this_.Lastname as Lastname0_2_, order1_.OrderId as OrderId1_0_, order1_.OrderDate as OrderDate1_0_, order1_.CustomerId as CustomerId1_0_, products5_.[Order] as Order1_, product2_.ProductId as Product, product2_.ProductId as ProductId3_1_, prod