Why can I delete entities that have associated entities?

Hi,

Ive been playing around with my experimental data service athttps://astoria.sandbox.live.com/users/quotemehappy/quotemehappy.rse

username=quoteit

password=quoteit

The service is very basic. Its a list of Persons and a list of Quotes for each of those Persons.

What bothers me is that I was able to insert a person, insert a quote for that person, and then delete the Person. the quote was deleted as well. I admit that my head is in relational database mode, but I happen to think that the service shouldnt let us do that. Iit should throw the equivalent of a FK violation.

Thoughts?

Thanks

Jamie

[831 byte] By [JamieThomson] at [2008-2-8]
# 1

Sorry, I'm wrong. The quotes are still there, they've just been orphaned that's all. Still, I don't particularly like that behaviour either. What's the rationale here?

Thanks

Jamie

JamieThomson at 2007-10-2 > top of Msdn Tech,Incubation Technologies,Project Codename: Astoria...
# 2
I agree the semantics of the service could be improved in this scenario. It is now on our todo list of upgrades. Thanks for the feedback.

MikeFlasko at 2007-10-2 > top of Msdn Tech,Incubation Technologies,Project Codename: Astoria...