I have 2 dachshunds
A standard and a mini, boy and girl, both fixed.
The female mini, Candi (stripper name) loves me.
Oscar, the red standard, adores my wife, stands guard for her when she's in the bathroom or in the bedroom changing....sits in the doorway challenging in a polite but honest way.
They are smooth haired, so shedding is zero problem.
They are crate trained and love to get in them.
Can be a bit aggressive in play with small children and they will bark. Loudly.
Intensely smart.
We had Toby, a red dachshund, that lived to be 16.
I let him out one night to pee....about 30 minutes later I heard noise in the carport. Toby had stolen and dragged home an entire chicken from someone's BBQ grill. The steam was still rising from the chicken!
Still don't know how he did it nor do I know which neighbor he stole it from.
He was a ferocious hunter of squirrels and rabbits, hiked his leg to pee in defiance of a Rottweiler on the other side of the fence and displayed incredible courage in his comical, sausage dog body.
Fearless!
I would have no other dog than the Dachshund.
I agree that the German Shepherd is a great dog and great with kids. Had one as a youth.
Good luck and get a dog!