Search code examples
sql-serverlocaldbsql-server-2014-localdbsql-server-2016-localdb

How can I specify to use SQL Server LocalDb 2014 rather than SQL Server LocalDb 2016 in the connection string?


Our application uses SQL Server LocalDb 2014 as the database engine. The connection string we use is

"Data Source=(localdb)\MSSQLLOCALDB;Initial Catalog=OurDatabase;MultipleActiveResultSets=True;Integrated Security=True;AttachDBFilename=|DataDirectory|OurDatabase.mdf"

Now, on just one of our computers, it has VS 2015SP3 and the latest version of the SQL Server objects installed, our application starts using SQL Server LocalDb 2016. This is undesirable as we exchange back-ups of the database files regularly between computers and now the back-ups that are made in the LocalDb 2016 format cannot be read on computers that do not have LocalDb 2016.

The problem is that the connection string does not specify which version of LocalDb should be used. It there a way to force LocalDb 2014 (or 2016, if we decide to upgrade?)


Solution

  • Well, seeing that apart from Erik's answer no solutions have been provided, we must assume that indeed you cannot specify which flavour of SQL Server LocalDb you wish to use when using "Data Source=(localdb)\mssqllocaldb" in a connection string.

    A drawback of Erik's solution is that it does not play nice with other applications that may use the default instance of LocalDb (MSSQLLocalDb). I found a different approach in using a so called named instance: an instance of LocalDb private to your application. While defining a named instance you can specify the version of LocalDb you want to use: 12.0 for LocaldDb 2014, 13.0 for Localdb 2016.

    There are two ways to create a named instance:

    1. Using the sqllocaldb commandline tool:

    SqlLocalDB.exe create "MyNamedInstance" 12.0 -s

    The -s parameter starts the instance immediately.

    1. Specifying the named instance in app.config:

    For this add to the <configSections> tag:

    <section name="system.data.localdb"
             type="System.Data.LocalDBConfigurationSection,System.Data,Version=4.0.0.0,Culture=neutral,PublicKeyToken=b77a5c561934e089"/>
    

    Then add a new tag:

    <system.data.localdb>
        <localdbinstances>
          <add name="MyNamedInstance" version="12.0" />
        </localdbinstances>
    </system.data.localdb>
    

    You can now specify the named instance in the connection string thus:

    "Data Source=(localdb)\mynamedinstance"