SubSonic error: db.tables with name ~ in name results in "Character is not valid" error
I renamed the database table and added the ~ symbol to the table name (my way of communicating that this is backup
something). After generating SubSonic files, my Visual Studio gives "Character not valid" error in "AllStructs.vb" file
When viewing this file, the following line of code was generated; Public Shared ReadOnly DbTable1 ~ old As String = "dbtable1 ~ old".
I am guessing this symbol should be filtered from db.table names when creating SubSonic names?
You can use stripTableText / stripSPText to remove ~ from class names, or you can use regexReplaceExpression to replace ~ with another character.
You need to specify this in your configuration when creating your classes, see "Configuration Parameters " for more details.
a source to share
This kind of naming is not supported by SubSonic (conventions and all). Your best bet is to use includeTableList and excludeTableList (or one of the other options we have):
http://subsonicproject.com/configuration/config-options/
To help you get rid of old things.