SQL LocalDB Wrapper v1.13.0.0

SqlLocalDb v1.13.0.0

New Features

• Added new system.data.sqlLocalDb custom configuration section. The settings are documented here.
• Added static DefaultInstanceName property to the SqlLocalDbApi class.
• Added GetDefaultInstance() extension method for the ISqlLocalDbProvider interface.
• All references to CodePlex in the source code have been updated to GitHub.

Bug Fixes

• Fixed inability to create the default named instances of SQL LocalDB (i.e. v11.0 or MSSQLLocalDB).
• Fixed the GetOrCreateInstance() extension method for the ISqlLocalDbInstance interface not being able to correctly determine if the instance already exists if the instance name is one of the default instance names.
• Fixed directory traversal flaw in the internal SqlLocalDbApi.DeleteInstanceFiles(string) method. This was not exploitable by the public API as the native SQL LocalDB Instance API rejects calls to LocalDBDeleteInstance() with such names so DeleteInstanceFiles() was never called.
• The path to the native SQL LocalDB Instance API DLL read from the registry is now canonicalized using System.IO.Path.GetFullPath() before being used.

SQL LocalDB Wrapper v1.12.0.0

SqlLocalDb v1.12.0.0

New Features

• Added the following new members to the TemporarySqlLocalDbInstance class to make managing the files for temporary instances easier.
  • TemporarySqlLocalDbInstance .ctor(string instanceName, ISqlLocalDbProvider provider, bool deleteFiles)
  • TemporarySqlLocalDbInstance Create(bool deleteFiles)

Bug Fixes

• Fixed code path where the value of the SqlLocalDbApi.AutomaticallyDeleteInstanceFiles property was not honoured when deleting instances.

SQL LocalDB Wrapper v1.11.0.0

SqlLocalDb v1.11.0.0

New Features

• Added the following new members to the SqlLocalDbApi class to allow the files associated with a SQL LocalDB instance to be deleted when the instance is deleted. The previous behaviour is retained when using the existing deletion methods. The default value of the SqlLocalDbApi.AutomaticallyDeleteInstanceFiles property can be overridden using the SQLLocalDB:AutomaticallyDeleteInstanceFiles application configuration setting.
  • bool SqlLocalDbApi.AutomaticallyDeleteInstanceFiles
  • void SqlLocalDbApi.DeleteInstance(string instanceName, bool deleteFiles)
  • int SqlLocalDbApi.DeleteUserInstances(bool deleteFiles)
• Added SqlLocalDbApi.GetInstancesFolderPath() method to obtain the path to which the SQL LocalDB instance files are stored on the local machine for the current user.

Bug Fixes

• Small change to P/Invoke calls that receive strings as output parameters.
• Fixes to some XML documentation comments.

SQL LocalDB Wrapper v1.10.0.0

SqlLocalDb v1.10.0.0

New Features

• Added the ability to change the logging implementation by setting an ILogger instance via the Logger.SetLogger(ILogger) method.
• The assembly no longer directly references the System.Data.Entity assembly, and now creates the types used from it using reflection instead.
• SqlLocalDbApi.DeleteUserInstances() now ignores any errors caused by instances that cannot be deleted because the instance is in use.

Bug Fixes

• Changed some log messages to use "Obtaining"/"Obtained" instead of "Getting"/"Obtained".
• Fixed two log messages with quoted format values that only had a start quote and no end quote.

SQL LocalDB Wrapper v1.9.0.0

SqlLocalDb v1.9.0.0

New Features

• Added new TemporarySqlLocalDbInstance class which helps manage temporary instances used for a limited period of time, such as for testing purposes. The instances created by this class are automatically started and are deleted when the instances are the class are disposed.
• Added the Restart() convenience extension method to the ISqlLocalDbInstance interface.

SQL LocalDB Wrapper v1.8.0.0

SqlLocalDb v1.8.0.0

New Features

• Support for Microsoft SQL LocalDB 2014.
• Added functionality to the SqlLocalDbProvider class to allow the version used to create instances to be changed easily via the new Version property.
• Added the DeleteUserInstances() method to the SqlLocalDbApi class to allow throw-away instances on the local machine to be easily cleaned-up.
• The SQLLocalDB:OverrideVersion application setting can now be used to override the version of the SQL LocalDB native API loaded, instead of the default behaviour of loading the latest version installed on the local machine.

Bug Fixes

• Fixed SqlLocalDbApi.ShareInstance() not passing the marshalled value for ownerSid to the underlying native LocalDB API function.
• Fixed SqlLocalDbApi.LatestVersion returning the oldest version number, not the latest version, when SQL LocalDB 2012 and 2014 are installed on the same machine.
• Fixed incorrect trace event Id being used if an SQL LocalDB instance was successfully deleted.
• Fixed typo in resource string.
• FxCop and SecAnnotate fixes to NativeMethods for targeting .NET 3.5 and .NET 4.0.

SQL LocalDB Wrapper v1.7.0.0

SqlLocalDb v1.7.0.0

• Removed processor-specific native code from the solution. All native dependencies are now only those related to SQL LocaDB itself. This means the wrapper now ships as a single .NET assembly (System.Data.SqlLocalDb.dll) which is compiled as AnyCPU.
• Added ability to control the behaviour when shutting down a SQL LocalDB instance using the new StopInstanceOptions enumeration via the SqlLocalDbApi.StopOptions property and the SqlLocalDbApi.StopInstance(string, StopInstanceOptions, TimeSpan) method overload.

SQL LocalDB Wrapper v1.6.0.0

SqlLocalDb v1.6.0.0

• Changes to have the managed code automatically use the native library with the appropriate bitness for the executing processor architecture.
• Fixed typo in XML documentation.
• Improvements to build automation.
• Updated to the latest versions of EntityFramework and Moq.
• The non-core projects now target .NET Framework 4.5.1.

SQL LocalDB Wrapper v1.5.0.0

SqlLocalDb v1.5.0.0

Added the following new members:

• string DbConnectionStringBuilder.GetPhysicalFileName()
• void DbConnectionStringBuilder.SetPhysicalFileName(string)

SQL LocalDB Wrapper v1.4.0.0

SqlLocalDb v1.4.0.0

Added the following new members:

• void DbConnectionStringBuilder.SetInitialCatalogName(string)
• SqlConnectionStringBuilder ISqlLocalDbInstance.CreateConnectionStringBuilder()
• ISqlLocalDbInstance ISqlLocalDbProvider.GetOrCreateInstance(string)

Fixed SqlLocalDbProvider.GetInstances() only ever returning the default instance.

Added sample application that shows use of the assembly with EntityFramework.