I have been working through the tutorials and sample apps for the past week. But I havent been able to find an example of what I am trying to do and havent had much success in my experimentaiton.
Heres the skinny... I have a person class (id, firstname, lastname, cellphone). I have a phone class (id, areacode, prefix, postfix). These two clasess releate to a table for each (person and phone). Simple enough...
What I would like to do is create a one-to-one relationship. Anytime I create a person and add a cellphone (instance of phone) to them. I would like to have the id of the phone record to have its reference (id) stored in the cellphone column of the person table.
All the examples I have seen appear to do this logic in reverse...they would store the personId in the phone table and then add some sort of 'type' (cell, home, etc) to the phone class.
Ultimately I would like to have multiple phone numbers attached to a person cellphone and homephone would be attributes of person. The would each be columns in the person table that would hold onto the Id from the phone table.
Heres my code...If someone could point me in the right direction it would be greatly appreciated.
One other question...Guid? Is this the best way to do things or should I let MSSQL auto number my PK's?
Person.cs
using System;
namespace SS
{
public class Person
{
private Guid personId;
private string firstName;
private string lastName;
private Phone cellPhone;
public Person()
{
}
public Guid PersonId
{
get { return personId; }
set { personId = value; }
}
public string FirstName
{
get { return firstName; }
set { firstName = value; }
}
public string LastName
{
get { return lastName; }
set { lastName = value; }
}
public Phone CellPhone
{
get { return cellPhone; }
set { cellPhone = value; }
}
}
}
Phone.cs
using System;
namespace SS
{
public class Phone
{
private Guid phoneId;
private string areaCode;
private string prefix;
private string postfix;
public Phone()
{
}
public Guid PhoneId
{
get { return phoneId; }
set { phoneId = value; }
}
public string AreaCode
{
get { return areaCode; }
set { areaCode = value; }
}
public string Prefix
{
get { return prefix; }
set { prefix = value; }
}
public string Postfix
{
get { return postfix; }
set { postfix = value; }
}
}
}
Person.hbm.xml
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="SS.Person, SS" table="Person">
<id name="PersonId" column="PersonId" type="Guid" unsaved-value="00000000-0000-0000-0000-000000000000">
<generator class="guid" />
</id>
<property name="FirstName" column="FirstName" type="String" />
<property name="LastName" column="LastName" type="String" />
<one-to-one name="CellPhone" class="SS.Phone, SS" cascade="all" constrained="true" property-ref="PhoneId"/>
</class>
</hibernate-mapping>
Phone.hbm.xml
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="SS.Phone, SS" table="Phone">
<id name="PhoneId" column="PhoneId" type="Guid" unsaved-value="00000000-0000-0000-0000-000000000000">
<generator class="guid" />
</id>
<property name="AreaCode" column="AreaCode" type="String" />
<property name="Prefix" column="Prefix" type="String" />
<property name="Postfix" column="Postfix" type="String" />
</class>
</hibernate-mapping>
my tables...
CREATE TABLE [Person] (
[PersonID] [uniqueidentifier] NOT NULL ,
[FirstName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LastName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CellPhone] [uniqueidentifier] NULL ,
CONSTRAINT [PK_Person] PRIMARY KEY CLUSTERED
(
[PersonID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [Phone] (
[PhoneId] [uniqueidentifier] NOT NULL ,
[AreaCode] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Prefix] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Postfix] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
CONSTRAINT [PK_Phone] PRIMARY KEY CLUSTERED
(
[PhoneId]
) ON [PRIMARY]
) ON [PRIMARY]
GO
code im testing with:
Configuration cfg = new Configuration();
cfg.AddAssembly("SS");
ISessionFactory factory = cfg.BuildSessionFactory();
ISession session = factory.OpenSession();
ITransaction transaction = session.BeginTransaction();
Person newUser = new Person();
newUser.FirstName = "JosephFirst";
newUser.LastName = "SmithLast";
Phone newCellPhone = new Phone();
newCellPhone.AreaCode = "410";
newUser.CellPhone = newCellPhone;
session.Save(newUser);
transaction.Commit();
session.Close();
Login
FAQ
Search
