I think it'll depend on the age of the dog, age of the children and where you get the dog from.
My family had a Spaniel when I was born, and she was very calm and collected around my siblings and I when we were babies/toddlers. My parents got her from a breeder (not puppy mills, but a reputable one) when they first got married. She was an ideal pet.
My current dog my dad bought on impulse from a pet store after one of my mom's childhood friend died. She is much more temperamental with everyone--children and adults. If you try to take food from her, she'll growl and might try to bite the person. With my family she is the most comfortable and can be very sweet and loving, we try to keep her in her cage when guests come over. With all of the health problems she's had on top of her somewhat aggressive attitude and the fact she came from a pet store, I'm pretty convinced she's a puppy mill dog.
I'd say do your research as far as the place you get the dog goes.