CommandBuilder...why and why not
I spent last week developing our data management layer. Most of my testing was done with the CommandBuilder. Although it is a handy type, I found some limitations, so I developed our own custom model. I wish Bill's article would have come out a week sooner:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/CommandBuilder.asp