Thanks for the reply. I agree. I broke up the entities and it works out better. thanks
On Wed, May 27, 2009 at 12:57 AM, James Gregory <[email protected]> wrote: > I'm not sure if there's an easy way to do this. You could try using > <join>/WithTable, but I'm fairly sure that'll get upset if you have multiple > schools using the same SchoolSystem record. Personally, I'd reevaluate your > entity design. It sounds like it should just be a many-to-one/References. > > On Wed, May 27, 2009 at 1:18 AM, John <[email protected]> wrote: >> >> I'm not sure how I would do this. Any help would be appreciated. >> Basically I am trying to create a mapping for 2 tables to create 1 >> entity called School. Below are the table schemas and my entity im >> trying to map to. SchoolSystemID is not unique. Meaning each School >> can have one SchoolSystem and a SchoolSystem can belong to multiple >> Schools. >> >> >> ----------------------------------------------------------------------------------------- >> >> CREATE TABLE [dbo].[School]( >> [SchoolID] [int] IDENTITY(1,1) NOT NULL, >> [SchoolSystemID] [int] NOT NULL, >> [SchoolName] [varchar](50) NOT NULL, >> ) >> GO >> ALTER TABLE [dbo].[School] WITH CHECK ADD FOREIGN KEY >> ([SchoolSystemID]) >> REFERENCES [dbo].[SchoolSystem] ([SchoolSystemID]) >> >> >> ------------------------------------------------------------------------------------------- >> >> CREATE TABLE [dbo].[SchoolSystem]( >> [SchoolSystemID] [int] IDENTITY(1,1) NOT NULL, >> [CountyName] [varchar](50) NOT NULL, >> [SchoolSystemName] [varchar](50) NOT NULL, >> ) >> ALTER TABLE [dbo].[SchoolSystem] WITH CHECK ADD FOREIGN KEY >> ([CountyName]) >> REFERENCES [dbo].[County] ([CountyName]) >> >> >> ------------------------------------------------------------------------------------------- >> >> public class School >> { >> public virtual int ID { get; set; } >> public virtual string Name { get; set; } >> public virtual string CountyName { get; set; } >> } >> >> > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Fluent NHibernate" 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/fluent-nhibernate?hl=en -~----------~----~----~----~------~----~------~--~---
