I'm new to NHibernate / Fluent NHibernate (started with it this weekend)
and I'm having difficulties solving the following.
I have 2 SQL Server tables:
[Client]
ID INT NOT NULL IDENTITY(1,1)
Name VARCHAR(100) NOT NULL
Email VARCHAR(255) NOT NULL
BirthDate DATE
[Phones]
ID INT NOT NULL IDENTITY(1,1)
Number VARCHAR(14)
Category INT ClientID INT NOT NULL FOREIGN KEY REFERENCES [Client](ID)
POCO classes:
public class Clients
{
public virtual int ID { get; set; }
public virtual string Name { get; set; }
public virtual string Email { get; set; }
public virtual DateTime BirthDate { get; set; }
public virtual Phones Phones { get; set; }
}
public class Phones
{
public virtual int ID { get; set; }
public virtual string Number { get; set; }
public virtual PhoneCategory.PCategory Category { get; set; }
public virtual Clients Client { get; set; }
}
public static class PhoneCategory
{
public enum PCategory
{
Personal,
Comercial,
Residential,
Other
}
}
Mappings:
public class ClientsMap : ClassMap<Clients>
{
public ClientsMap()
{
Table("Clients");
Id(x => x.ID);
Map(x => x.Name);
Map(x => x.Email);
Map(x => x.BirthDate);
References(x => x.Phones).Column("ClientID").Cascade.All();
}
}
public class PhonesMap : ClassMap<Phones>
{
public PhonesMap()
{
Table("Phones");
Id(x => x.ID);
Map(x => x.Number);
Map(x => x.Category).CustomType<PhoneCategory.PCategory>();
}
}
My view for the Clients class is working fine, I can save, update, list and
delete. But how could I include the records of the Phones class?
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/nhusers/80bec1bf-92a3-4c08-b4af-b2210ec91038n%40googlegroups.com.
