One thing in C# I really like is the @ which lets you define strings spanning multiple rows. It sure makes your code much more easy to read and I often use it when I need to build up dynamic SQL, for example
string sSQL = @"select a_traceclicks.*, a_banner.name as banname, a_adposition.name as adposname, a_zone.zonename from a_traceclicks, a_banner, a_adposition, a_zone where a_adposition.id=a_traceclicks.adposid and .... a_banner.id=a_traceclicks.bannerid";
That makes it much more easier to understand than just one long row. However, under the hood, the result string does contain a lot of "invisible" characters - \n, \r. \t etc.
MySQL doesn't like this so the solution is to do string concatenation instead:
string sSQL = @"select a_traceclicks.*, a_banner.[name] as banname, "; sSQL += " a_adposition.[name] as adposname, "; sSQL += "a_zone.zonename "; sSQL += " from a_traceclicks, a_banner, a_adposition, a_zone where "; sSQL += " a_adposition.id=a_traceclicks.adposid and "; sSQL += ... sSQL += " a_banner.id=a_traceclicks.bannerid";
