DevForce Community Forum : Cascading Delete Trouble

Cascading Delete Trouble : I got it sorted guys The problem...

Thu, 02 Aug 2007 03:33:56 -700

Author: Darren
Subject: 339
Posted: 02-Aug-2007 at 3:33am

I got it sorted guys

The problem lay in my database schema , there was a relationship problem there.

I have a Matrix table linked to the contacts table.

The matrix holds 2 fields contactid and accountid

The contact table should have been the Parent and the Matrix the child , but i had it reversed

cheers

Wed, 01 Aug 2007 16:25:21 -700

Author: TrevLeyb
Subject: 339
Posted: 01-Aug-2007 at 4:25pm

From looking at this (and without seeing what Me.Contact actually is), I would suggest that Me.Contact is an ENTITY and not an ENTITYLIST.

So you are trying to cast a ENTITY (singular) to a ENTITYLIST (plural) whcih would give the error you are reporting.

Wed, 01 Aug 2007 15:29:08 -700

Author: naveen.menon
Subject: 339
Posted: 01-Aug-2007 at 3:29pm

new EntityList only has 2 overloads.

1) new EntityList()

2) new EntityList(IEnumerable pCollection)

In your code, Me.Contact seems erroneous. Is that the line, your code breaks at?

Mon, 30 Jul 2007 07:46:55 -700

Author: Darren
Subject: 339
Posted: 30-Jul-2007 at 7:46am

I keep getting this error in my developer class when i go to delete a contact.

Me.Contact being the relation property between the parent and the child class.

here is the code:

Public Function DeleteGraph() As Integer

Dim numberOfItemsDeleted As Integer = 0

Dim contactDetails As EntityList(Of Model.Contact) = New EntityList(Of Model.Contact)(Me.Contact)

Dim contactDetailsCount As Integer = contactDetails.Count

Dim counter As Integer = 0

Do While counter < contactDetailsCount

contactDetails(0).Delete()

counter += 1

Loop

Me.Delete()

Return (contactDetailsCount + 1)

End Function