OK, i created a even more simple test and now with different column and property names.
<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
namespace="Vita.Pesa.Domain"
assembly="Vita.Pesa" xmlns="urn:nhibernate-mapping-2.2">
<class
name="TempTestClass"
lazy="true"
table="TempTestClass">
<id
name="TempId"
column="Id"
type="Int32">
<generator
class="identity" />
</id>
<property
name="Name"
type="String"
column="Name"
length="200"
not-null="true" />
<joined-subclass
name="SubTempTestClass"
lazy="true"
extends="TempTestClass"
table="SubTempTestClass"
>
<key
column="TempTestClassId" />
<property
name="Name"
type="String"
column="Name"
length="200"
not-null="true" />
</joined-subclass>
</class>
</hibernate-mapping>
Code:
namespace Vita.Pesa.Domain
{
public class TempTestClass
{
private int _tempId;
private string name;
public virtual int TempId
{
get { return _tempId; }
set { _tempId = value; }
}
public virtual string Name
{
get { return name; }
set { name = value; }
}
}
public class SubTempTestClass : TempTestClass
{
private int _subTempId;
private string _name;
public virtual int SubTempId
{
get { return _subTempId; }
set { _subTempId = value; }
}
public new virtual string Name
{
get { return _name; }
set { _name = value; }
}
}
}
The Database schema:
CREATE TABLE [dbo].[TempTestClass](
[TempId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_TempTestClass] PRIMARY KEY CLUSTERED
(
[TempId] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[SubTempTestClass](
[SubTempId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TempTestClassId] [int] NOT NULL,
CONSTRAINT [PK_SubTempTestClass] PRIMARY KEY CLUSTERED
(
[SubTempId] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SubTempTestClass] WITH CHECK ADD CONSTRAINT [FK_SubTempTestClass_TempTestClass] FOREIGN KEY([TempTestClassId])
REFERENCES [dbo].[TempTestClass] ([TempId])
GO
ALTER TABLE [dbo].[SubTempTestClass] CHECK CONSTRAINT [FK_SubTempTestClass_TempTestClass]
The test code:
using (ISession session = NHibernateUtil.GetCurrentSession())
using (ITransaction tx = session.BeginTransaction())
{
SubTempTestClass testClass = new SubTempTestClass();
testClass.Name = "name";
session.SaveOrUpdate(testClass);
Assert.IsNotNull(testClass);
Assert.AreEqual(testClass.Name, "name", "Client.Name = 'name'");
Console.Write("SubTempClass id: " + testClass.SubTempId.ToString() + ", TempClass id: " + ((TempTestClass)testClass).TempId.ToString());
Assert.AreNotEqual(((TempTestClass)testClass).TempId, 0, "TempTestClass ID should not be 0!");
Assert.AreNotEqual(testClass.SubTempId, 0, "SubTempTestClass ID should not be 0!");
session.Delete(testClass);
tx.Commit();
}
Generated SQL by nHibernate:
NHibernate: INSERT INTO TempTestClass (Name) VALUES (@p0); select SCOPE_IDENTITY(); @p0 = 'name'
NHibernate: INSERT INTO SubTempTestClass (Name, TempTestClassId) VALUES (@p0, @p1); @p0 = 'name', @p1 = '17'
This should not happen. Basicly, it is not selecting the ID from the joined-subclass table. Why ? How could i make it return it ?
I am doing my mapping configuration wrong somewhere on both cases? I must be doing something wrong ?
Login
FAQ
Search
