A space in the name of a class is unsupported in
any .NET language, however a table name can still have
spaces in it. An example is in the sample 'Northwind'
database table 'Order Details'.
New tags for table/field names with no spaces should be
added. The templates should use the new tags where
used as a name of a class/property. The tag with the
white space is still needed for creating the
CommandText for CRUD commands. The CRUD
command's CommandText should have brackets '[...]'
around the table/field name when there is a space.
Maybe the brackets can be part of the replacement
text? If the field/tablename contains a space, then
automatically add the '[...]' around the name?
Otherwise the templates need to always place the
brackets around names to account for the times they
are needed.
In either case, preserve backwards compatibility of the
current tags usage.
Possible additions...
[TABLENAME_NS] - table name with no spaces (primarily
used in class/property names)
[TABLENAME_LOWER_NS] - table name lower case with
no spaces (primarily used in local variable names)
[TABLENAME_SQL] - sql string for tablename - if name
has spaces places brackets around name (no lowercase
version needed). (used in CommandText of CRUD
command statements)
same naming convention for tags of type [FIELDNAME]
and [PKNAME]