Subsonic 3.0 - Prefix all column names

Question

Hi,

Problem.

• Subsonic 3 build against an existing, medium sized DB
• Lots of columns, some badly named so conflicting against reserved words, Subsonic functions etc.
• Want to be able to prefix all column names (not tables) with something, eg. 'c' for column so that the appear together in intellisense drop down and solve naming issues in one foul swoop.

I'm comfortable with hacking the tt templates and core source but can't quite work out the best way to do this without causing 100's of errors or only fixing half of the generated source. The general opinion is to use CleanUp() but I don't see how you target columns only with this.

I need the changes to also work with linq queries (e.g for use with .SingleOrDefault)

Thanks

Ed