Have Geek Brain

SubSonic, SQL Server and MySQL Task Table Names [ClienteEndereco Clienteendereco]

I did tests with SubSonic with SQL Server and everything was fine.

I decided to install MySQL and run the same tests, but now I have a small problem.

My table name is ClienteEndereco in SQL Server, but when I make changes to my web.config to work with MYSQL and recompiles the program, the table name goes into Clienteendereco

SQL Server = Cliente**E**ndereco
MySql      = Cliente**e**ndereco

I tried to use regexIgnoreCase="true"

but nothing happens.

Can anyone help with solving this? How do I do subsonic "case ignore" in SQL Server and MySql?

Thanks.

  <add name="mssql" 
       type="SubSonic.SqlDataProvider, SubSonic" 
       connectionStringName="mssql" 
       fixPluralClassNames="false" 
       generatedNamespace="ModeloDados" 
       regexMatchExpression="A-Za-z" 
       regexIgnoreCase="true" 
       removeUnderscores="false" 
       setPropertyDefaultsFromDatabase="true" 
       generateNullableProperties="true" 
       useExtendedProperties="true" 
       useUtc="true"/>
0


a source to share


2 answers


I founded one way. I used "regexDictionaryReplace". This way works in mysql and mssql

  <add name="mysql" type="SubSonic.MySqlDataProvider, SubSonic"
             regexDictionaryReplace="Empresaendereco,EmpresaEndereco"
             fixDatabaseObjectCasing="true" connectionStringName="mysql"
             generateRelatedTablesAsProperties="true"
             fixPluralClassNames="false"
             generatedNamespace="ModeloDados"
             regexIgnoreCase="true"
             removeUnderscores="false"
             setPropertyDefaultsFromDatabase="true"
             generateNullableProperties="true"
             useExtendedProperties="true"
             useUtc="true" />


Thanks for the help!

0


a source


As Pavell pointed out, MySQL on Windows and OS X only uses lowercase names for tables by default. There is a configuration option that you can use to change this behavior. The following blog post gives a quick overview:



MySQL Sensitivity Issues

0


a source






More articles:


All Articles