Circular associations error

Hi,

I am getting the circular association error for one to many relationship between two tables. I have this kind of relationship with other tables, I am not sure why I am getting this error on these two tables. Please, let me know how to fix it.

 Circular associations are not supported by LightSpeed: [TableObject.Attachments and Attachment.TableObject]

 Thanks!

Could you post your model please?  It's hard to say what might be different about these two entities without seeing the code.  Thanks!

Thanks for your help. I have pasted the class code generated for Attachment and Object table.

Attachment table code:----------------------------------------------------------------

 <Serializable()> _
    <System.CodeDom.Compiler.GeneratedCode("LightSpeedModelGenerator", "1.0.0.0")> _
    <Table(IdColumnName:="ATTACHMENT_ID")> _
    Partial Public Class Attachment
        Inherits Entity(Of Integer)

        <Column("OBJECT_PK")> _
        Private _objectPk As Integer

        <Column("FILE_NAME"), ValidatePresence(), ValidateLength(0, 500)> _
        Private _fileName As String

        <Column("FILE_CONTENT"), ValidatePresence()> _
        Private _fileContent As Byte()


        <Column("ATTACHMENT_TYPE_ID")> _
        Private _attachmentTypeId As Integer

        <Column("OBJECT_ID")> _
        Private _objectId As Integer

        Public Const ObjectPkField As String = "ObjectPk"
        Public Const FileNameField As String = "FileName"
        Public Const FileContentField As String = "FileContent"
        Public Const AttachmentTypeIdField As String = "AttachmentTypeId"
        Public Const ObjectIdField As String = "ObjectId"


        <ReverseAssociation("Attachments")> _
        Private ReadOnly _attachmentType As New EntityHolder(Of AttachmentType)()
        <ReverseAssociation("Attachments")> _
        Private ReadOnly _tableObject As New EntityHolder(Of TableObject)()

        Public Sub New()
            MyBase.New(False)
            Initialize()
        End Sub

        Protected Sub New(ByVal initialize As Boolean)
            MyBase.New(initialize)
        End Sub

        Public Property ObjectPk() As Integer
            Get
                Return [Get](_objectPk)
            End Get
            Set(ByVal value As Integer)
                [Set](_objectPk, value, "ObjectPk")
            End Set
        End Property

        Public Property FileName() As String
            Get
                Return [Get](_fileName)
            End Get
            Set(ByVal value As String)
                [Set](_fileName, value, "FileName")
            End Set
        End Property

        Public Property FileContent() As Byte()
            Get
                Return [Get](_fileContent)
            End Get
            Set(ByVal value As Byte())
                [Set](_fileContent, value, "FileContent")
            End Set
        End Property

        Public Property AttachmentTypeId() As Integer
            Get
                Return [Get](_attachmentTypeId)
            End Get
            Set(ByVal value As Integer)
                [Set](_attachmentTypeId, value, "AttachmentTypeId")
            End Set
        End Property

        Public Property ObjectId() As Integer
            Get
                Return [Get](_objectId)
            End Get
            Set(ByVal value As Integer)
                [Set](_objectId, value, "ObjectId")
            End Set
        End Property



        Public Property AttachmentType() As AttachmentType
            Get
                Return [Get](Of AttachmentType)(_attachmentType)
            End Get
            Set(ByVal value As AttachmentType)
                [Set](Of AttachmentType)(_attachmentType, value)
            End Set
        End Property

        Public Property TableObject() As TableObject
            Get
                Return [Get](Of Object)(_tableObject)
            End Get
            Set(ByVal value As TableObject)
                [Set](Of Object)(_tableObject, value)
            End Set
        End Property


    End Class

--------------------------------------------------------------

 TableObject code: ---------------------------------------------------------------------

    <Serializable()> _
    <System.CodeDom.Compiler.GeneratedCode("LightSpeedModelGenerator", "1.0.0.0")> _
    <Table(IdColumnName:="OBJECT_ID")> _
    Partial Public Class TableObject
        Inherits TwistEntity(Of Integer)

        <Column("OBJECT_NAME"), ValidatePresence(), ValidateLength(0, 30)> _
        Private _objectName As String

        Public Const ObjectNameField As String = "ObjectName"

        <ReverseAssociation("TableObject")> _
        Private ReadOnly _attachments As New EntityCollection(Of Attachment)()


        Public Sub New()
            MyBase.New(False)
            Initialize()
        End Sub

        Protected Sub New(ByVal initialize As Boolean)
            MyBase.New(initialize)
        End Sub

        Public Property ObjectName() As String
            Get
                Return [Get](_objectName)
            End Get
            Set(ByVal value As String)
                [Set](_objectName, value, "ObjectName")
            End Set
        End Property

        Public ReadOnly Property Attachments() As EntityCollection(Of Attachment)
            Get
                Return [Get](Of Attachment)(_attachments)
            End Get
        End Property

    End Class

Thanks.  Could you also post AttachmentType please, just so we can get a full picture of the associations involved (I don't *think* this can be an indirect circular association, but I'd like to be sure!).  I also noticed that TableObject inherits from TwistEntity(Of Integer).  Can you confirm that TwistEntity doesn't introduce any associations or other persistent fields?  Thanks!

I don't think Attachment type should be an issue but I have posted the code below. TwistEntity just inherits Entity class and inculdes common fields of all the tables.

Attachment type table:

 <Serializable()> _
    <System.CodeDom.Compiler.GeneratedCode("LightSpeedModelGenerator", "1.0.0.0")> _
    <Table("ATTACHMENT_TYPE", IdColumnName:="ATTACHMENT_TYPE_ID")> _
    Partial Public Class AttachmentType
        Inherits TwistEntity(Of Integer)

        <Column("ATTACHMENT_TYPE_CODE"), ValidatePresence(), ValidateLength(0, 10)> _
        Private _attachmentTypeCode As String

        <Column("ATTACHMENT_TYPE_NAME"), ValidatePresence(), ValidateLength(0, 30)> _
        Private _attachmentTypeName As String


        Public Const AttachmentTypeCodeField As String = "AttachmentTypeCode"
        Public Const AttachmentTypeNameField As String = "AttachmentTypeName"


        <ReverseAssociation("AttachmentType")> _
        Private ReadOnly _attachments As New EntityCollection(Of Attachment)()

        Public Sub New()
            MyBase.New(False)
            Initialize()
        End Sub

        Protected Sub New(ByVal initialize As Boolean)
            MyBase.New(initialize)
        End Sub

        Public Property AttachmentTypeCode() As String
            Get
                Return [Get](_attachmentTypeCode)
            End Get
            Set(ByVal value As String)
                [Set](_attachmentTypeCode, value, "AttachmentTypeCode")
            End Set
        End Property

        Public Property AttachmentTypeName() As String
            Get
                Return [Get](_attachmentTypeName)
            End Get
            Set(ByVal value As String)
                [Set](_attachmentTypeName, value, "AttachmentTypeName")
            End Set
        End Property

        Public ReadOnly Property Attachments() As EntityCollection(Of Attachment)
            Get
                Return [Get](Of Attachment)(_attachments)
            End Get
        End Property


    End Class

 ----------------------------

TwistEntity code: --------------

Public MustInherit Class TwistEntity(Of T)
        Inherits Entity(Of Integer)

        <Column("CREATED_BY"), ValidatePresence(), ValidateLength(0, 30)> _
        Private _createdBy As String

        <Column("CREATED_DT")> _
        Private _createdDt As Date

        <Column("LAST_UPDATED_BY"), ValidateLength(0, 30)> _
        Private _lastUpdatedBy As String

        <Column("LAST_UPDATED_DT")> _
        Private _lastUpdatedDt As System.Nullable(Of Date)

        Public Const IdField As String = "Id"
        Public Const CreatedByField As String = "CreatedBy"
        Public Const CreatedDtField As String = "CreatedDt"
        Public Const LastUpdatedByField As String = "LastUpdatedBy"
        Public Const LastUpdatedDtField As String = "LastUpdatedDt"

        Public Sub New()
            MyBase.New(False)
            Initialize()
        End Sub

        Protected Sub New(ByVal initialize As Boolean)
            MyBase.New(initialize)
        End Sub


        Public Property CreatedBy() As String
            Get
                Return [Get](_createdBy)
            End Get
            Set(ByVal value As String)
                [Set](_createdBy, value, "CreatedBy")
            End Set
        End Property

        Public Property CreatedDt() As Date
            Get
                Return [Get](_createdDt)
            End Get
            Set(ByVal value As Date)
                [Set](_createdDt, value, "CreatedDt")
            End Set
        End Property

        Public Property LastUpdatedBy() As String
            Get
                Return [Get](_lastUpdatedBy)
            End Get
            Set(ByVal value As String)
                [Set](_lastUpdatedBy, value, "LastUpdatedBy")
            End Set
        End Property

        Public Property LastUpdatedDt() As System.Nullable(Of Date)
            Get
                Return [Get](_lastUpdatedDt)
            End Get
            Set(ByVal value As System.Nullable(Of Date))
                [Set](_lastUpdatedDt, value, "LastUpdatedDt")
            End Set
        End Property

    End Class

The problem appears to be that in the Attachment class, there is no foreign key field for the TableObject association.  This makes LightSpeed think that the TableObject association is the "parent" (PK) end of a one-to-one association.  So now it has an association both ends of which appear to be "parent" ends, neither of them having a foreign key, which it interprets (rather misleadingly I admit) as a circular association.

Now I suspect that what you actually intend is that the _objectId field be the foreign key for the TableObject association.  In this case in needs to be named _tableObjectId so as to match up with the _tableObject EntityHolder.  However the designer should really be creating this field for you and I am not sure why it is not doing so (or is giving it the wrong name).

If you have copied these files from the ones generated by the designer, and edited them by hand, then all you need to do is change _objectId to _tableObjectId.

If these files are the ones generated by the designer, could you provide your .lsmodel and .lsmodel.diagram files so we can try to figure out why the foreign key field is not being generated or is being generated incorrectly?  Thanks!