To be clear, the answer to all this is "it depends". For basic bread-and-butter updates, yes, linq2sql (and ORM) works great.