To Control or not to Control... that is the question!!!

I'm currently workin with a team of C# Developers where I'm acting as a technical lead - along with another individual that is very savvy when it comes to C# and OOP.
We've taken the Model View Controller approach in developing this new application we're working on these days. We question how much liability we should put on the controllers object when performing CRUD operations. We'd like to take it on a case-by-case basis but to be absolutely sure about this I wanted to post to see what the majority is practicing these days.

Take for example:

A controller object for the customer object may be responsible for calling stored procedures for inserting, selecting, updating and deleting.

But lets take another example:

Would I create a controller object for each Order and OrderDetail? Taking this even further, would every object be responsible for its own CRUD operations? Or would it make sense to allow a single controller object to manipulate for both Order and OrderDetail since the relation is pretty obvious? Or another option would be to allow each controller object to controller its own CRUD where it makes sense?

Your responses are greatly appreciated!!!

Working at Fox

I began working at 20th Century Fox in Century City, Ca around the begining of Sept 2005. In the few weeks that I've been here I've seen some pretty cool stuff while walking the movie sets. What I think is the coolest of all is the occasional movie star appearance. I work at the actual filming lot so it's not far-fetch that I would run into well known actors - I'm not sure if these are actually them but the two that I've seen on the lot are Helen Hunt (from the movie What Women Want) and the girl from the movie American Pie (you know the one that always says, "One day at band camp I...").

These people are earning a buck here at the Fox Lot (probably earning a little more than my buck - but never the less) so I tend to leave them alone. However, I did get a smile from Helen Hunt as she was driving by in one of the little golf carts they have here in the lot.