I wonder if someone could please advise what is the established best practice for NHibernate to work with Composite keys.
<?xml version="1.0" encoding="utf-8" ?>
<!-- NHibernate mapping file, generated 29/09/2006 12:13
This file must be saved with a .hbm.xml extension and must be set to be compiled as an Embedded Resource. -->
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="Duke.DIMPLE2.NHibernate.OutletStockItem, Duke.DIMPLE2" table="STO_OutletStockItem">
<composite-id name="CompositeKey" class="Duke.DIMPLE2.NHibernate.OutletStockItemCompositeKey, Duke.DIMPLE2">
<key-property name="Outl_Code"/>
<key-property name="SIte_Code"/>
</composite-id>
<property name="SGro_Code" column="SGro_Code" type="string" length="6" />
<property name="SIte_Price" column="SIte_Price" type="System.Int32" />
<property name="SIte_IsStocked" column="SIte_IsStocked" type="System.Boolean" />
<property name="SIte_IsDiscount" column="SIte_IsDiscount" type="System.Boolean" />
<property name="SIte_IsDropShip" column="SIte_IsDropShip" type="System.Boolean" />
<property name="SIte_SupplierCode" column="SIte_SupplierCode" type="string" length="10" />
<property name="SIte_MaxStockQty" column="SIte_MaxStockQty" type="System.Int32" />
<property name="SIte_MinStockQty" column="SIte_MinStockQty" type="System.Int32" />
<property name="SIte_VATCode" column="SIte_VATCode" type="string" length="1" />
<property name="SIte_StandardCost" column="SIte_StandardCost" type="System.Int32" />
<property name="SIte_AverageCost" column="SIte_AverageCost" type="System.Int32" />
<property name="SIte_CostOfSale" column="SIte_CostOfSale" type="System.Int32" />
<property name="SIte_TradeNetPrice" column="SIte_TradeNetPrice" type="System.Int32" />
</class>
</hibernate-mapping>
using System;
using System.Collections;
using System.Collections.Generic;
using System.Configuration;
using System.Text;
using Duke.Lib.NHibernate;
using NHibernate;
using Nullables;
using Nullables.NHibernate;
using Duke.Lib.Serialization;
using Duke.Lib.Serialization.Providers;
namespace Duke.DIMPLE2.NHibernate
{
public class OutletStockItem : NHibernateBase {
private string _sGro_Code = "";
private int _sIte_Price = 0;
private bool _sIte_IsStocked = false;
private bool _sIte_IsDiscount = false;
private bool _sIte_IsDropShip = false;
private string _sIte_SupplierCode = "";
private int _sIte_MaxStockQty = 0;
private int _sIte_MinStockQty = 0;
private string _sIte_VATCode = "";
private int _sIte_StandardCost = 0;
private int _sIte_AverageCost = 0;
private int _sIte_CostOfSale = 0;
private int _sIte_TradeNetPrice = 0;
private OutletStockItemCompositeKey _compositeKey=new OutletStockItemCompositeKey();
#region ~ Properties ~
public OutletStockItemCompositeKey CompositeKey
{
get { return _compositeKey; }
set { _compositeKey=value; }
}
/// <summary>
/// Gets/sets the SGro_Code property.
/// </summary>
/// <value>The value to set or that is returned.</value>
public string SGro_Code
{
get { return _sGro_Code; }
set { _sGro_Code = value; }
}
/// <summary>
/// Gets/sets the SIte_Price property.
/// </summary>
/// <value>The value to set or that is returned.</value>
public int SIte_Price
{
get { return _sIte_Price; }
set { _sIte_Price = value; }
}
/// <summary>
/// Gets/sets the SIte_IsStocked property.
/// </summary>
/// <value>The value to set or that is returned.</value>
public bool SIte_IsStocked
{
get { return _sIte_IsStocked; }
set { _sIte_IsStocked = value; }
}
/// <summary>
/// Gets/sets the SIte_IsDiscount property.
/// </summary>
/// <value>The value to set or that is returned.</value>
public bool SIte_IsDiscount
{
get { return _sIte_IsDiscount; }
set { _sIte_IsDiscount = value; }
}
/// <summary>
/// Gets/sets the SIte_IsDropShip property.
/// </summary>
/// <value>The value to set or that is returned.</value>
public bool SIte_IsDropShip
{
get { return _sIte_IsDropShip; }
set { _sIte_IsDropShip = value; }
}
/// <summary>
/// Gets/sets the SIte_SupplierCode property.
/// </summary>
/// <value>The value to set or that is returned.</value>
public string SIte_SupplierCode
{
get { return _sIte_SupplierCode; }
set { _sIte_SupplierCode = value; }
}
/// <summary>
/// Gets/sets the SIte_MaxStockQty property.
/// </summary>
/// <value>The value to set or that is returned.</value>
public int SIte_MaxStockQty
{
get { return _sIte_MaxStockQty; }
set { _sIte_MaxStockQty = value; }
}
/// <summary>
/// Gets/sets the SIte_MinStockQty property.
/// </summary>
/// <value>The value to set or that is returned.</value>
public int SIte_MinStockQty
{
get { return _sIte_MinStockQty; }
set { _sIte_MinStockQty = value; }
}
/// <summary>
/// Gets/sets the SIte_VATCode property.
/// </summary>
/// <value>The value to set or that is returned.</value>
public string SIte_VATCode
{
get { return _sIte_VATCode; }
set { _sIte_VATCode = value; }
}
/// <summary>
/// Gets/sets the SIte_StandardCost property.
/// </summary>
/// <value>The value to set or that is returned.</value>
public int SIte_StandardCost
{
get { return _sIte_StandardCost; }
set { _sIte_StandardCost = value; }
}
/// <summary>
/// Gets/sets the SIte_AverageCost property.
/// </summary>
/// <value>The value to set or that is returned.</value>
public int SIte_AverageCost
{
get { return _sIte_AverageCost; }
set { _sIte_AverageCost = value; }
}
/// <summary>
/// Gets/sets the SIte_CostOfSale property.
/// </summary>
/// <value>The value to set or that is returned.</value>
public int SIte_CostOfSale
{
get { return _sIte_CostOfSale; }
set { _sIte_CostOfSale = value; }
}
/// <summary>
/// Gets/sets the SIte_TradeNetPrice property.
/// </summary>
/// <value>The value to set or that is returned.</value>
public int SIte_TradeNetPrice
{
get { return _sIte_TradeNetPrice; }
set { _sIte_TradeNetPrice = value; }
}
#endregion
/// <summary>
/// Initializes a new instance of the <see cref="T:OutletStockItem"/> class.
/// </summary>
public OutletStockItem()
{
Initialise(typeof(OutletStockItem));
}
/// <summary>
/// Finds all <see cref="T:OutletStockItem" /> items.
/// </summary>
/// <returns>
/// Returns an array of <see cref="T:OutletStockItem" /> items.
/// </returns>
public static OutletStockItem[] FindAll()
{
return (OutletStockItem[])FindAll(typeof(OutletStockItem));
}
/// <summary>
/// Finds all <see cref="T:OutletStockItem" /> items according to the specified <c>outl_Code</c> value.
/// </summary>
/// <param name="outl_Code">The Outl_Code value to search for.</param>
/// <returns>
/// Returns an array of <see cref="T:OutletStockItem" /> items.
/// </returns>
public static OutletStockItem[] FindByOutl_Code(string outl_Code)
{
Initialise(typeof(OutletStockItem));
ISession iSession=PrepareForTransaction(typeof(OutletStockItem));
ICriteria iCriteria=iSession.CreateCriteria(typeof(OutletStockItem))
.Add(
global::NHibernate.Expression.Expression.Eq("Outl_Code", outl_Code));
IList iList=iCriteria.List();
iSession.Transaction.Commit();
iSession.Close();
Array array=Array.CreateInstance(typeof(OutletStockItem), iList.Count);
return (OutletStockItem[])array;
}
/// <summary>
/// Finds all <see cref="T:OutletStockItem" /> items according to the specified <c>sIte_Code</c> value.
/// </summary>
/// <param name="sIte_Code">The SIte_Code value to search for.</param>
/// <returns>
/// Returns an array of <see cref="T:OutletStockItem" /> items.
/// </returns>
public static OutletStockItem[] FindBySIte_Code(string sIte_Code)
{
Initialise(typeof(OutletStockItem));
ISession iSession=PrepareForTransaction(typeof(OutletStockItem));
ICriteria iCriteria=iSession.CreateCriteria(typeof(OutletStockItemCompositeKey))
.Add(
global::NHibernate.Expression.Expression.Eq("SIte_Code", sIte_Code));
IList iList=iCriteria.List();
iSession.Transaction.Commit();
iSession.Close();
Array array=Array.CreateInstance(typeof(OutletStockItem), iList.Count);
return (OutletStockItem[])array;
}
/// <summary>
/// Finds all <see cref="T:OutletStockItem" /> items according to the specified <c>sIte_Code</c> value.
/// </summary>
/// <param name="sIte_Code">The SIte_Code value to search for.</param>
/// <returns>
/// Returns an array of <see cref="T:OutletStockItem" /> items.
/// </returns>
public static OutletStockItem FindBySIte_CodeAndOutl_Code(string sIte_Code,string outl_Code)
{
Initialise(typeof(OutletStockItem));
ISession iSession=PrepareForTransaction(typeof(OutletStockItem));
ICriteria iCriteria=iSession.CreateCriteria(typeof(OutletStockItem))
.Add(
new global::NHibernate.Expression.AndExpression(
global::NHibernate.Expression.Expression.Eq("SIte_Code", sIte_Code),
global::NHibernate.Expression.Expression.Eq("Outl_Code",outl_Code)));
IList iList=iCriteria.List();
iSession.Transaction.Commit();
iSession.Close();
if (iList.Count==1)
{
return (OutletStockItem)iList[0];
}
else return null;
}
public OutletStockItem Save()
{
return (OutletStockItem)base.Save(typeof(OutletStockItem));
}
}
[Serializable()]
public class OutletStockItemCompositeKey : NHibernateBase {
private string _outl_Code=string.Empty;
private string _sIte_Code=string.Empty;
#region ~ Properties ~
public string Outl_Code
{
get { return _outl_Code; }
set { _outl_Code=value; }
}
public string SIte_Code
{
get { return _sIte_Code; }
set { _sIte_Code=value; }
}
#endregion
#region ~ from Object ~
public override bool Equals(object obj)
{
OutletStockItemCompositeKey outletStockItemCompKey=obj as OutletStockItemCompositeKey;
if (outletStockItemCompKey!=null)
{
return outletStockItemCompKey.Outl_Code==this.Outl_Code &&
outletStockItemCompKey.SIte_Code==this.SIte_Code;
}
return false;
}
public override int GetHashCode()
{
return Outl_Code.GetHashCode()+SIte_Code.GetHashCode();
}
#endregion
}
}
Compiles fine, but doesn't seem to be pulling anythign back for the FindBySIte_Code() method.
Login
FAQ
Search
