[fluent-nhib] Re: Establishing a relationship other than the Primary key

2009-06-19 Thread Allen Wilson
Thanks...I read through it again and I did see the PropertyRef information you were referring to. Tried it and it still did not help my issue...the way the tables are set up there is a one to many relationshp...therefore i need the HasMany but without the field in table A being the primary key I a

[fluent-nhib] Re: Establishing a relationship other than the Primary key

2009-06-19 Thread Allen Wilson
Tried to use the HasManyToMany and it actually caused the same problem that I have in another post. The relationship is not a HasManyToManythere can only be one ACCOUNT_ID in table (there is a unique index set on itto the poor design again). I need to use the HasOneToMany but be able to i

[fluent-nhib] Re: Problem with populating tablesq

2009-06-19 Thread Allen Wilson
No problem Here is the map: public class ApplicationInformation_Map : ClassMap, IMap { private string _table; public string Table { get { return _table; } } public ApplicationInformation_Map() { _table = "ACCOU

[fluent-nhib] Establishing a relationship other than the Primary key

2009-06-19 Thread Allen Wilson
Hello I am trying to set up a relationship with HasMany In table A, I have the fields GUID_ACCOUNT_ID (primary key) and ACCOUNT_ID. In table B, I have the fields TRANS_ID and ACCOUNT_ID. The ACCOUNTID is a foreign key for ACCOUNT_ID in table A (yes...the table is somewhat badly designed

[fluent-nhib] Problem with populating tablesq

2009-06-19 Thread Allen Wilson
Hello... I am using Fluent NHibernate to work with a new system I am putting together and developing with Test-Driven Development (TDD). To conduct my test, I am using SQLite as the database end and I am having problems populating the tables. It looks like the error is due to using the Reference