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
|
Hello, Consider the following LightSpeed configuration my configuration file.
<connectionStrings>
<!--<add name="Db" connectionString="Data Source=(local);Initial Catalog=bla;User ID=sa;Password=password" providerName="System.Data.SqlClient" />--> <add name="Db" connectionString="server=localhost;User Id=root;Pwd=password;database=bla" providerName="MySql.Data.MySqlClient" /> </connectionStrings>
<lightSpeedContexts> <add name="Cloud" connectionStringName="Db" pluralizeTableNames="true" /> </lightSpeedContexts> I don't specify the provider type as I'm hoping to use the same configuration for both MySQL and SQL Server by simply changing the connection string. However, as per documentation, LightSpeed will default to SQL Server. This is error prone. Any chance that LightSpeed can derive its provider from the connection string's providerName if one is supplied? For example, if its "MySQL.Data.MySqlClient", then MySQL will be used. If its "System.Data.SqlClient", then SQL Server 2005 will be used. This will simplify the configuration of applications. Thanks, Werner
|
|
|
|
