Dec 24, 2009 03:41 AM|XIII|LINK
refactoring's a job regularly done. Resharper from JetBrains is a good assistant for this.
On the other hand we use an ORM mappers (Linq to Sql) which generates the classes for us when we, after changing a table, drop it again on the designer of the dbml. Besides that we have custom written datatypes which closely resemble our tables but we do
fill them up in the DAL layer by L2S statements. Whenever some database change happens we only need to adapt our DAL layer while the other layers (business, service, UI, ...) mostly stay the same. If it's a big change of naming convention we adapt the datatype
also and use Resharper to change for the refactoring.
Also we use custom objects for transportation of the datatypes instead of passing in every "column" in the method signature. When we need to refactor then we don't have to change all these method parameters also.