This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I have the following situation. The production server is using Windows & MySql configuration (Windows is required because of using Photon Socket server). This forces the table names to be all lower case (see http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvarlowercasetablenames). The local test server I use has MySql running in Ubuntu. So with phpMyAdmin I renamed all table names to lower case and used an underscore where needed. The (small) bug: When adding all tables to the model view within visual studio all names got converted nicely to Pascal styled names. The names that contained an underscore were correctly used at the Table Name property. However the Table Name property did not get set for names that did not have an underscore. This resulted in an error because the app was trying to access a capitalized version of the table name. This was of course quickly fixed by entering the lower case names at the Table Name properties. The question: I was trying to use the KeyTable method for getting unique identifiers. However I need to use a lowercase version of the table name; is it possible to specify somewhere an alternate table name for the KeyTable (for example key_table or keytable)? Thanks, Josha |
|
|
|
|
Hi Josha, In order to override the KeyTable naming you will need to implement a custom naming strategy and then assign this to be used by assigning it to the LightSpeedContext.CustomNamingStrategy property for the context instance which you are using. Here is a thread which contains an example of a custom naming strategy which you can use as a start point, it sounds like you will just want to set this up to lower case and/or include underscores are required. http://www.mindscapehq.com/forums/thread/2337
|
|
|
|
