Use FirstOrDefault to actually run the query.
Added test for cascading delete.
Fixup of test.
Updated tests with cascading delete.
Added a missing foreign key.
The rights isn't competition specific and should not be deleted with competition.
Lots of changes to handle recursive delete.
Moved creating a competition to a separate view.