you forgot the "cascade" for the collection (HasMany)
On Tue, Feb 3, 2009 at 3:56 AM, Lars <[email protected]> wrote:
>
> I'm very new to NHibernate and Fluent. I've done OK with mapping a
> single object, but my first object containing a collection is not
> working. It seems that my mapping is not saving the collection.
>
> The parent table is ZipcodeSet and the child collection is
> ZipcodeSetDetail. Can anyone see what I have done wrong?
>
> Thanks, Lars
>
> public class ZipcodeSet
> {
> private string _description;
> private IList<ZipcodeSetDetail> _zipCodeSetDetail;
>
> public ZipcodeSet(string description)
> {
> _description = description;
> initMembers();
> }
>
> public ZipcodeSet() {}
>
> public virtual string Description
> {
> get { return _description; }
> set { _description = value; }
> }
>
> public virtual IList<ZipcodeSetDetail> Details
> {
> get { return _zipCodeSetDetail; }
> protected set { _zipCodeSetDetail = value; }
> }
>
> private void initMembers()
> {
> _zipCodeSetDetail = new List<ZipcodeSetDetail>();
> }
> }
>
> public class ZipcodeSetDetail
> {
> private string _zipCode;
>
> public ZipcodeSetDetail(string zipCode)
> {
> _zipCode = zipCode;
> }
>
> public ZipcodeSetDetail() {}
>
> public virtual string ZipCode
> {
> get { return _zipCode; }
> set { _zipCode = value; }
> }
> }
>
> Mapping:
> WithTable("ZipcodeSet");
> Id(c => c.ID)
> .WithUnsavedValue(0)
> .GeneratedBy.Native();
> Map(c => c.Description)
> .WithLengthOf(50);
> HasMany<ZipcodeSetDetail>(c => c.Details)
> .IsInverse()
> .WithKeyColumn("ZipCodeSetId")
> .AsBag();
>
> WithTable("ZipcodeSetDetail");
> Id(c => c.ID)
> .WithUnsavedValue(0)
> .GeneratedBy.Native();
> Map(c => c.ZipCode)
> .WithLengthOf(5);
>
>
> Testing:
>
> protected override void LoadTestData()
> {
> ZipcodeSetDetail zipcodeSetDetail1 = saveDetail(new
> ZipcodeSetDetail("90048"));
> ZipcodeSetDetail zipcodeSetDetail2 = saveDetail(new
> ZipcodeSetDetail("90049"));
> ZipcodeSet set1 = new ZipcodeSet("First set");
> set1.Details.Add(zipcodeSetDetail1);
> saveEntity(set1);
> ZipcodeSet set2 = new ZipcodeSet("First two");
> set1.Details.Add(zipcodeSetDetail1);
> set1.Details.Add(zipcodeSetDetail2);
> saveEntity(set2);
> }
>
> private void saveEntity(ZipcodeSet set)
> {
> _repository.SaveOrUpdate(set);
> FlushSessionAndEvict(set);
> }
>
> private ZipcodeSetDetail saveDetail(ZipcodeSetDetail detail)
> {
> _repositoryDetail.SaveOrUpdate(detail);
> FlushSessionAndEvict(detail);
> return detail;
> }
>
> public void CanGetEntityById()
> {
> ZipcodeSet set = _repository.Get(1);
> Assert.That(set.Description, Is.EqualTo("First set"));
> Assert.That(set.Details.Count, Is.EqualTo(1));
> }
>
> SQL results:
> NHibernate: INSERT INTO ZipcodeSetDetail (ZipCode) VALUES (@p0);
> select last_insert_rowid(); @p0 = '90048'
> NHibernate: INSERT INTO ZipcodeSetDetail (ZipCode) VALUES (@p0);
> select last_insert_rowid(); @p0 = '90049'
> NHibernate: INSERT INTO ZipcodeSet (Description) VALUES (@p0); select
> last_insert_rowid(); @p0 = 'First set'
> NHibernate: INSERT INTO ZipcodeSet (Description) VALUES (@p0); select
> last_insert_rowid(); @p0 = 'First two'
> NHibernate: SELECT zipcodeset0_.ID as ID2_0_, zipcodeset0_.Description
> as Descript2_2_0_ FROM ZipcodeSet zipcodeset0_ WHERE
> zipcodeset0_....@p0; @p0 = '1'
> NHibernate: SELECT detail0_.ZipCodeSetId as ZipCodeS3_1_, detail0_.ID
> as ID1_, detail0_.ID as ID3_0_, detail0_.ZipCode as ZipCode3_0_ FROM
> ZipcodeSetDetail detail0_ WHERE detail0_.zipcodeset...@p0; @p0 = '1'
> TestCase
> 'PowRev.Tests.DataIntegration.ZipcodeSetIntegrationTests.CanGetEntityById'
> failed:
> Expected: 1
> But was: 0
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
