c# - Switching dynamicaly database in ASP.NET

Question

I have to create a multilanguage application based on ASP.NET MVC 4. Unfortunately,a one database suits a one language. The structure and terminology are the same as opposed to the content which is changing. Is there any possibility for the application to change a database according to choice of the language?

Answer 1

Add different connection strings to your web.config - one for each supported language:

<connectionStrings>
  <clear/>
  <add name="northwind-en" connectionString="server=(local);database=NorthwindEnglish;Integrated Security=SSPI"/>
  <add name="northwind-fr" connectionString="server=(local);database=NorthwindFrench;Integrated Security=SSPI"/>
</connectionStrings>

Then select connection string depending on required language, or default one if there is no specific database for selected language:

var availableLocales = ConfigurationManager.ConnectionStrings
                                .Cast<ConnectionStringSettings>()
                                .Select(cs => cs.Name)
                                .Select(n => n.Substring(n.IndexOf('-') + 1));