I have some MySQL written as String in my VB.NET application. Sometimes Visual Studio (2015 Community) changes the format of some parts of the string that it thinks its a keyword.
Example.:
Command.CommandText = "DROP TABLE IF EXISTS `table_name`"
is changed to:
Command.CommandText = "DROP TABLE If EXISTS `table_name`"
In this case it is just annoing and not harmful, but I can think of situations where this could cause some problems. Case sensitive string comparison, for instance. Another problem is that distracts from the real modifications when using a version control.
To me its seems like a bug in the current release. For now how can I avoid this?