There have been some reoccouring questions:
How do I move a web service
How do I keep my code updated with respect to changes in my database structure.
There stock answers are:
You should never need to move a web service.
You should design your database up-front so it should not need to change.
These are grossly simplified. I have encountered a case where a website had to move due to legal questions about the name – the site had been located where it was for a year. Web services can and will suffer the same fate.
Database structures will change. We had to add an entire subsystem to the product that we are working on to support one line in the requirements. Change happens. The trick is to use tools that minimise that change. That can mean restricting the use of strongly typed datasets.
Guys please think about your snappy answers.