Hi experts,
i have big problems with cascading deletes in entityframework 6.
i have a simple database with just 2 tables, persons and addresses,
each Person can have 0 or many addresses -> 1:n relationship.
When i delete a person all addresses are also deleted -> GREAT!
But when i try to delete all addresses of a person i get an exception:
"The operation failed: The relationship could not be changed because one or more of the foreign-key properties is non-nullable. When a change is made to a relationship, the related foreign-key property is set to a null value. If the foreign-key does not support null values, a new relationship must be defined, the foreign-key property must be assigned another non-null value, or the unrelated object must be deleted."
I have searched the Internet the last 2 days and the only thing i found that should work was to create a combined Primary key, but this also does not work for me.
Thanks
Manuel