public void Throws_InvalidOperationException_If_SQL_LocalDB_Not_Installed()
{
// Arrange
var options = new SqlLocalDbOptions();
var registry = Mock.Of <Interop.IRegistry>();
using (var actual = new SqlLocalDbApi(options, registry, _loggerFactory))
{
// Act and Assert
Assert.Throws <InvalidOperationException>(() => actual.CreateInstance("name"));
Assert.Throws <InvalidOperationException>(() => actual.DeleteInstance("name"));
Assert.Throws <InvalidOperationException>(() => actual.DeleteUserInstances());
Assert.Throws <InvalidOperationException>(() => actual.GetDefaultInstance());
Assert.Throws <InvalidOperationException>(() => actual.GetInstanceInfo("name"));
Assert.Throws <InvalidOperationException>(() => actual.GetInstanceNames());
Assert.Throws <InvalidOperationException>(() => actual.GetInstances());
Assert.Throws <InvalidOperationException>(() => actual.GetOrCreateInstance("name"));
Assert.Throws <InvalidOperationException>(() => actual.GetVersionInfo("name"));
Assert.Throws <InvalidOperationException>(() => actual.InstanceExists("name"));
Assert.Throws <InvalidOperationException>(() => actual.LatestVersion);
Assert.Throws <InvalidOperationException>(() => actual.ShareInstance("name", "sharedName"));
Assert.Throws <InvalidOperationException>(() => actual.StartInstance("name"));
Assert.Throws <InvalidOperationException>(() => actual.StartTracing());
Assert.Throws <InvalidOperationException>(() => actual.StopInstance("name"));
Assert.Throws <InvalidOperationException>(() => actual.StopTracing());
Assert.Throws <InvalidOperationException>(() => actual.UnshareInstance("name"));
}
}
public void Can_Create_SqlLocalDB_Instances_With_Different_Versions()
{
// Arrange
using (var actual = new SqlLocalDbApi(_loggerFactory))
{
foreach (string version in actual.Versions)
{
// Act
ISqlLocalDbVersionInfo versionInfo = actual.GetVersionInfo(version);
// Assert
versionInfo.ShouldNotBeNull();
versionInfo.Name.ShouldStartWith(version.Split('.').First());
versionInfo.Exists.ShouldBeTrue();
versionInfo.Version.ShouldNotBeNull();
versionInfo.Version.ShouldNotBe(new Version());
string instanceName = Guid.NewGuid().ToString();
// Act
ISqlLocalDbInstanceInfo instanceInfo = actual.CreateInstance(instanceName, version);
// Assert
instanceInfo.ShouldNotBeNull();
instanceInfo.Name.ShouldBe(instanceName);
instanceInfo.Exists.ShouldBeTrue();
instanceInfo.IsRunning.ShouldBeFalse();
instanceInfo.LocalDbVersion.ShouldBe(versionInfo.Version);
// Act (no Assert)
actual.DeleteInstance(instanceName);
actual.DeleteInstanceFiles(instanceName);
}
}
}
public void Throws_PlatformNotSupportedException()
{
// Arrange
using (var actual = new SqlLocalDbApi(_loggerFactory))
{
// Act and Assert
Assert.Throws <PlatformNotSupportedException>(() => actual.CreateInstance("name"));
Assert.Throws <PlatformNotSupportedException>(() => actual.DeleteInstance("name"));
Assert.Throws <PlatformNotSupportedException>(() => actual.DeleteUserInstances());
Assert.Throws <PlatformNotSupportedException>(() => actual.GetDefaultInstance());
Assert.Throws <PlatformNotSupportedException>(() => actual.GetInstanceInfo("name"));
Assert.Throws <PlatformNotSupportedException>(() => actual.GetInstanceNames());
Assert.Throws <PlatformNotSupportedException>(() => actual.GetInstances());
Assert.Throws <PlatformNotSupportedException>(() => actual.GetOrCreateInstance("name"));
Assert.Throws <PlatformNotSupportedException>(() => actual.GetVersionInfo("name"));
Assert.Throws <PlatformNotSupportedException>(() => actual.InstanceExists("name"));
Assert.Throws <PlatformNotSupportedException>(() => actual.LatestVersion);
Assert.Throws <PlatformNotSupportedException>(() => actual.ShareInstance("name", "sharedName"));
Assert.Throws <PlatformNotSupportedException>(() => actual.ShareInstance("sid", "name", "sharedName"));
Assert.Throws <PlatformNotSupportedException>(() => actual.StartInstance("name"));
Assert.Throws <PlatformNotSupportedException>(() => actual.StartTracing());
Assert.Throws <PlatformNotSupportedException>(() => actual.StopInstance("name"));
Assert.Throws <PlatformNotSupportedException>(() => actual.StopTracing());
Assert.Throws <PlatformNotSupportedException>(() => actual.UnshareInstance("name"));
}
}
public void Methods_Validate_Parameters()
{
// Arrange
TimeSpan timeout = TimeSpan.Zero.Add(TimeSpan.FromTicks(-1));
using (var actual = new SqlLocalDbApi(_loggerFactory))
{
// Act and Assert
Assert.Throws <ArgumentNullException>("instanceName", () => actual.CreateInstance(null, "version"));
Assert.Throws <ArgumentNullException>("version", () => actual.CreateInstance("instanceName", null));
Assert.Throws <ArgumentNullException>("instanceName", () => actual.DeleteInstance(null));
Assert.Throws <ArgumentNullException>("instanceName", () => actual.GetInstanceInfo(null));
Assert.Throws <ArgumentNullException>("version", () => actual.GetVersionInfo(null));
Assert.Throws <ArgumentNullException>("ownerSid", () => actual.ShareInstance(null, "instanceName", "sharedInstanceName"));
Assert.Throws <ArgumentNullException>("instanceName", () => actual.ShareInstance("ownerSid", null, "sharedInstanceName"));
Assert.Throws <ArgumentNullException>("sharedInstanceName", () => actual.ShareInstance("ownerSid", "instanceName", null));
Assert.Throws <ArgumentException>("instanceName", () => actual.ShareInstance("sid", string.Empty, "sharedInstanceName"));
Assert.Throws <ArgumentNullException>("instanceName", () => actual.StartInstance(null));
Assert.Throws <ArgumentNullException>("instanceName", () => actual.StopInstance(null, TimeSpan.Zero));
Assert.Throws <ArgumentOutOfRangeException>("timeout", () => actual.StopInstance("instanceName", timeout)).ActualValue.ShouldBe(timeout);
Assert.Throws <ArgumentNullException>("instanceName", () => actual.UnshareInstance(null));
}
}
/// <summary> /// Returns information about the specified LocalDB version. /// </summary> /// <param name="version">The name of the LocalDB version to get the information for.</param> /// <returns> /// An instance of <see cref="ISqlLocalDbVersionInfo"/> containing information /// about the LocalDB version specified by <paramref name="version"/>. /// </returns> /// <exception cref="ArgumentNullException"> /// <paramref name="version"/> is <see langword="null"/>. /// </exception> /// <exception cref="InvalidOperationException"> /// SQL Server LocalDB is not installed on the local machine. /// </exception> /// <exception cref="SqlLocalDbException"> /// The information for the SQL Server LocalDB version specified by /// <paramref name="version"/> could not be obtained. /// </exception> public virtual ISqlLocalDbVersionInfo GetVersionInfo(string version) => SqlLocalDbApi.GetVersionInfo(version);