NHibernate(one-to-many)的问题

Question

<?xml version="1.0" encoding="utf-8" ?> 
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0"> 
 <class name="RG.SuperStarOA.Customers.Data.Customers,WebApplication1" table="Customers"> 
  <id name="CustomerID" column="CustomerID" type="String" length="5"> 
   <generator class="assigned" /> 
  </id> 
  <set name="Orders" > 
   <key column="CustomerID" /> 
   <one-to-many class="RG.SuperStarOA.Orders.Data.Orders,WebApplication1" /> 
  </set> 
  <property name="CompanyName" column="CompanyName" type="String" length="40"></property> 
  <property name="ContactName" column="ContactName" type="String" length="30"></property> 
  <property name="ContactTitle" column="ContactTitle" type="String" length="30"></property> 
  <property name="Address" column="Address" type="String" length="60"></property> 
  <property name="City" column="City" type="String" length="15"></property> 
  <property name="Region" column="Region" type="String" length="15"></property> 
  <property name="PostalCode" column="PostalCode" type="String" length="10"></property> 
  <property name="Country" column="Country" type="String" length="15"></property> 
  <property name="Phone" column="Phone" type="String" length="24"></property> 
  <property name="Fax" column="Fax" type="String" length="24"></property> 
 </class> 
</hibernate-mapping> 
<?xml version="1.0" encoding="utf-8" ?> 
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0"> 
 <class name="RG.SuperStarOA.Orders.Data.Orders,WebApplication1" table="Orders"> 
  <id name="OrderID" column="OrderID" type="Int32" length="4"> 
   <generator class="identity" /> 
  </id> 
  <many-to-one name="Customers" column="CustomerID" class="RG.SuperStarOA.Customers.Data.Customers,WebApplication1" /> 
  <property name="CustomerID" column="CustomerID" type="String" length="5"></property> 
  <property name="EmployeeID" column="EmployeeID" type="Int32" length="2"></property> 
  <property name="OrderDate" column="OrderDate" type="DateTime" length="4"></property> 
  <property name="RequiredDate" column="RequiredDate" type="DateTime" length="4"></property> 
  <property name="ShippedDate" column="ShippedDate" type="DateTime" length="4"></property> 
  <property name="ShipVia" column="ShipVia" type="Int32" length="4"></property> 
  <property name="Freight" column="Freight" type="Decimal" length="4"></property> 
  <property name="ShipName" column="ShipName" type="String" length="40"></property> 
  <property name="ShipAddress" column="ShipAddress" type="String" length="60"></property> 
  <property name="ShipCity" column="ShipCity" type="String" length="15"></property> 
  <property name="ShipRegion" column="ShipRegion" type="String" length="15"></property> 
  <property name="ShipPostalCode" column="ShipPostalCode" type="String" length="10"></property> 
  <property name="ShipCountry" column="ShipCountry" type="String" length="15"></property> 
 </class> 
</hibernate-mapping> 
<?xml version="1.0" encoding="utf-8" ?> 
    <hibernate-mapping xmlns="urn:nhibernate-mapping-2.0"> 
        <class name="RG.SuperStarSystem.Shippers.Data.Shippers,WebApplication1" table="Shippers"> 
            <id name="ShipperID" column="ShipperID" type="Int32" length="4"> 
                <generator class="identity"/> 
            </id> 
            <property name="CompanyName" column="CompanyName" type="String" length="40"></property> 
            <property name="Phone" column="Phone" type="String" length="24"></property> 
        </class> 
    </hibernate-mapping> //下面这段代码执行就完全没有问题 
private void Button3_Click(object sender, System.EventArgs e) 
  { 
   NHibernate.Cfg.Configuration c = new NHibernate.Cfg.Configuration(); 
   c.AddXmlFile(System.Web.HttpContext.Current.Server.MapPath("Customers.xml")); 
   c.AddXmlFile(System.Web.HttpContext.Current.Server.MapPath("Orders.xml")); 
   c.AddXmlFile(System.Web.HttpContext.Current.Server.MapPath("Shippers.xml")); 
    
   ISession vSession= c.BuildSessionFactory().OpenSession(); 
   ITransaction vTransaction = vSession.BeginTransaction();    try  
   {  
    IList data = vSession.Find("from Shippers");     DataGrid1.DataSource = data; 
    DataGrid1.DataBind(); 
     
    vTransaction.Commit();  
   } 
   catch(Exception ex)  
   {  
    vTransaction.Rollback();  
    Response.Write(ex.Message); 
   }  
   finally  
   {  
    vSession.Close();  
   } 
  } 
//这段代码去老是提示:Could not execute query  
private void Button2_Click(object sender, System.EventArgs e) 
  { 
   NHibernate.Cfg.Configuration c = new NHibernate.Cfg.Configuration(); 
   c.AddXmlFile(System.Web.HttpContext.Current.Server.MapPath("Customers.xml")); 
   c.AddXmlFile(System.Web.HttpContext.Current.Server.MapPath("Orders.xml")); 
   c.AddXmlFile(System.Web.HttpContext.Current.Server.MapPath("Shippers.xml")); 
    
   ISession vSession= c.BuildSessionFactory().OpenSession(); 
   ITransaction vTransaction = vSession.BeginTransaction();    try  
   {  
    IList data = vSession.Find("from Customers");     DataGrid1.DataSource = data; 
    DataGrid1.DataBind(); 
     
    vTransaction.Commit();  
   } 
   catch(Exception ex)  
   {  
    vTransaction.Rollback();  
    Response.Write(ex.Message); 
   }  
   finally  
   {  
    vSession.Close();  
   } 
  } 我测试来测试去，都是觉得是 
 <set name="Orders" > 
   <key column="CustomerID" /> 
   <one-to-many class="RG.SuperStarOA.Orders.Data.Orders,WebApplication1" /> 
  </set> 
或者，写查询语句有问题? 
谁能解决，拜托~` 

Answer 1

不要用set，用bag.用hbm2net生成根据你的xml生成cs文件。