What's Wrong with Strongly Typed Dataset Designer

I might be beating a dead horse here.But strongly typed dataset was giving me so much hard time that I have to rant about it. Actually strongly typed dataset is quite handy if all you have to do is just need to query or update a single table. The problem is that the real world is far less ideal than that. When you apply a suboptimal tool on a complicated, messy real world situation you are going to face a lot of problems. And this was exactly what happened when I was using strongly typed dataset designer in my work.