One to one relationship mapping with composite key

Question

Hi everybody, I have a database like this: My question is "How to mapping this database using castle active record?"

I've tried this code: Campaign:

[ActiveRecord("[Campaign]")]
    public class Campaign : ActiveRecordBase<Campaign>
    {
        private long m_ID;
        [PrimaryKey(Column = "`ID`")]
        public long ID
        {
            get { return m_ID; }
        set { m_ID = value; }
    }
        //// Properties ...
        private IList<MessageOfCampaign> m_MessageOfCampaign = new List<MessageOfCampaign>();
        [HasMany(typeof(MessageOfCampaign),
            Table = "`MessageOfCampaign`",            
            ColumnKey = "`CampaignID`")]
        public IList<MessageOfCampaign> MessagesOfCampaign
        {
            get { return m_MessageOfCampaign; }
            set { m_MessageOfCampaign = value; }
        }
    }

MessageOfCampaign:

[Serializable]
    public class MessageOfCampaignKey
    {
        private long m_MessageID;
        [KeyProperty(Column = "`MessageID`")]
        public long MessageID
        {
            get { return m_MessageID; }
            set { m_MessageID = value; }
        }

        private long m_CampaignID;
        [KeyProperty(Column = "`CampaignID`")]
        public long CampaignID
        {
            get { return m_CampaignID; }
            set { m_CampaignID = value; }
        }

        public override bool Equals(object obj)
        {
            if (this == obj)
            {
                return true;
            }

            MessageOfCampaignKey key = obj as MessageOfCampaignKey;

            if (key == null)
            {
                return false;
            }
            if (m_CampaignID != key.m_CampaignID || !m_MessageID.Equals(key.m_MessageID))
            {
                return false;
            }
            return true;
        }

        public override int GetHashCode()
        {
            return this.m_CampaignID.GetHashCode() ^ this.m_MessageID.GetHashCode();
        }
    }

    [ActiveRecord("[MessageOfCampaign]")]
    public class MessageOfCampaign : ActiveRecordBase<MessageOfCampaign>
    {
        private MessageOfCampaignKey m_Key;
        [CompositeKey]
        public MessageOfCampaignKey Key
        {
            get { return m_Key; }
            set { m_Key = value; }
        }

        private Message m_Message;
        [OneToOne]
        public Message Message
        {
            get { return m_Message; }
            set { m_Message = value; }
        }

        private Campaign m_Campaign;
        [BelongsTo("`CampaignID`")]
        public Campaign Campaign
        {
            get { return m_Campaign; }
            set { m_Campaign = value; }
        }
    }

Message:

[ActiveRecord("[Message]")]
    public class Message : ActiveRecordBase
    {
        private long m_ID;
        [PrimaryKey(Column = "`ID`")]
        public long ID
        {
            get { return m_ID; }
            set { m_ID = value; }
        }
        //// Properties ...

        [OneToOne]
        public MessageOfCampaign MessageOfCampaign
        {
            get { return this.m_MessageOfCampaign; }
            set { this.m_MessageOfCampaign = value; }
        }
     }

But I got the error:

broken column mapping for: MessageOfCampaign.id of: IMobileMarketing.Models.Message, type component[MessageID,CampaignID] expects 2 columns, but 1 were mapped

Answer 1

There seems to be something wrong with your ER diagram there. Shouldn't that be two 1-* relationships? Then you could just map it using the HasAndBelongsToMany attribute. E.g.

[ActiveRecord("[Campaign]")]
public class Campaign : ActiveRecordBase<Campaign>
{
   private IList<Message> m_Messages;

    [HasAndBelongsToMany(typeof(Message), 
        Table="MessageOfCampaign", ColumnKey="CapaignId", ColumnRef="MessageId")]
    public IList<Message> Messages
    {
        get { return m_Messages; }
        set { m_Messages = value; }
    }

   ...
}

[ActiveRecord("[Message]")]
public class Message : ActiveRecordBase
{
       private IList<Capaign> m_Capaigns;

        [HasAndBelongsToMany(typeof(Capaign), 
            Table="MessageOfCampaign", ColumnKey="MessageId", ColumnRef="CapaignId")]
        public IList<Capaign> Capaigns
        {
            get { return m_Capaigns; }
            set { m_Capaigns = value; }
        }

   ...
}