"I have marked the class 'Serializable' and overridden Equals and GetHashCode (although there were no compile error or exceptions when I did not do this)" nor would there be. By marking the object serializable you can serialize the configuration. This is useful if you want to save the configuration to file and then load it from file, rather than building the configuration each time. Equals and GetHashCode are used by the session to manage the identity map (1st level cache) not implementing them will not prevent complication, but you will get side effects in the session because the identity map may contain multiple instances of the same object)
the sql may not be generated because you have no properties associated wit the entity. if the entity is just city and providence you may want to consider mapping this as a list of components (value objects) rather than an entity. On Feb 19, 1:44 pm, John Davidson <[email protected]> wrote: > I could really use some help with this as it is taking too long todo > something I thought was relatively simple. > > I am unable to get data from a legacy table with a composite key. The > mapping, class and test query are below. I have marked the class > 'Serializable' and overridden Equals and GetHashCode (although there were no > compile error or exceptions when I did not do this). When the sample query > executes there is no sql (or exception) generated. > > <?xml version="1.0" encoding="utf-8" ?> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" > schema="HCOMS_USER" > assembly="SIS.Model" > namespace="SIS.Model"> > <class name="CityRef" table="CORE_CITY_TOWN"> > <composite-id> > <key-property name="CityName" column="CITY_TOWN_NAME_TXT" > type="string"/> > <key-property name="ProvinceCD" column="PROVINCE_CD" type="string"/> > </composite-id> > </class> > </hibernate-mapping> > > ================================================================= > > <Serializable()> _ > Public Class CityRef > Implements IAggregateRoot > > Private _cityName As String > Private _provinceCd As String > > Public Sub New() > > End Sub > > Public Sub New(ByVal CityName As String, ByVal ProvinceCd As String) > _cityName = CityName > _provinceCd = ProvinceCd > End Sub > > Public Overridable Property CityName() As String > Get > Return _cityName > End Get > Set(ByVal value As String) > _cityName = value > End Set > End Property > > Public Overridable Property ProvinceCD() As String > Get > Return _provinceCd > End Get > Set(ByVal value As String) > _provinceCd = value > End Set > End Property > > Public Overrides Function Equals(ByVal obj As Object) As Boolean > If obj Is Nothing Then > Return False > End If > Dim t As CityRef = CType(obj, CityRef) > If t Is Nothing Then > Return False > End If > If (Me._cityName = t._cityName AndAlso Me._provinceCd = > t._provinceCd) Then > Return True > Else > Return False > End If > End Function > > Public Overrides Function GetHashCode() As Integer > Return _cityName.GetHashCode Xor _provinceCd.GetHashCode > End Function > End Class > > ============================================================== > > Dim myList As IList(Of CityRef) = _ > SessionManager.GetCurrentSession _ > .CreateCriteria(GetType(CityRef)).List(Of > CityRef)() > > John Davidson -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
