SQL LocalDB Wrapper is a .NET library providing interop with the Microsoft SQL Server LocalDB Instance API from managed code using .NET APIs. The library targets netstandard2.0
, net6.0
and net8.0
.
This library exposes types that wrap the native SQL LocalDB Instance API to perform operations on SQL LocalDB such as for managing instances (create, delete, start, stop) and obtaining SQL connection strings for existing instances.
Microsoft SQL Server LocalDB 2012 and later is supported for both x86 and x64 on Microsoft Windows and the library targets netstandard2.0
.
While the library can be compiled and referenced in .NET applications on non-Windows Operating Systems, SQL LocalDB is only supported on Windows. Non-Windows Operating Systems can query to determine that the SQL LocalDB Instance API is not installed, but other usage will cause a PlatformNotSupportedException
to be thrown.
To install the library from NuGet using the .NET SDK run:
dotnet add package MartinCostello.SqlLocalDb
// using MartinCostello.SqlLocalDb;
using var localDB = new SqlLocalDbApi();
ISqlLocalDbInstanceInfo instance = localDB.GetOrCreateInstance("MyInstance");
ISqlLocalDbInstanceManager manager = instance.Manage();
if (!instance.IsRunning)
{
manager.Start();
}
using SqlConnection connection = instance.CreateConnection();
connection.Open();
// Use the SQL connection...
manager.Stop();
Further examples of using the library can be found by following the links below:
- The wiki.
- The sample application.
- The examples written as tests.
- The library's own tests.
Version 1.x.x
of this library was previously published as System.Data.SqlLocalDb
. The current version (3.x.x
) has been renamed and is a breaking change to the previous version with various changes to namespaces and types.
Version 2.x.x
of this library uses SQL types from the System.Data.SqlClient
namespace.
The current version (3.x.x
) uses the new Microsoft.Data.SqlClient NuGet package where the same types (such as SqlConnection
) are now in the Microsoft.Data.SqlClient
namespace.
To migrate a project from using the previous 2.x release, you should change usage of the System.Data.SqlClient
namespace to Microsoft.Data.SqlClient
and recompile your project.
Any feedback or issues can be added to the issues for this project in GitHub.
The repository is hosted in GitHub: https://github.com/martincostello/sqllocaldb.git
This project is licensed under the Apache 2.0 license.
Compiling the library yourself requires Git and the .NET SDK to be installed (version 8.0.100
or later).
For all of the tests to be functional you must also have at least one version of SQL LocalDB installed.
To build and test the library locally from a terminal/command-line, run the following set of commands:
Windows
git clone https://github.com/martincostello/sqllocaldb.git
cd sqllocaldb
./build.ps1
Note: To run all the tests successfully, you must run either build.ps1
or Visual Studio with administrative privileges. This is because the SQL LocalDB APIs for sharing LocalDB instances can only be used with administrative privileges. Not running the tests with administrative privileges will cause all tests that exercise such functionality to be skipped.
Note: Several tests are skipped on non-Windows Operating Systems as SQL LocalDB itself is only supported on Windows.
This library is copyright (©) Martin Costello 2012-2024.
Microsoft SQL Server is a trademark and copyright of the Microsoft Corporation.