public void SqlLocalDbInstance_CreateConnectionStringBuilder_If_Instance_Started()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
target.Start();
try
{
// Act
SqlConnectionStringBuilder result = target.CreateConnectionStringBuilder();
// Assert
Assert.IsNotNull(result, "CreateConnection() returned null.");
StringAssert.Contains(result.ConnectionString, target.NamedPipe, "SqlConnection.ConnectionString is incorrect.");
}
finally
{
SqlLocalDbApi.StopInstance(instanceName);
}
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbProvider_CreateInstance_Creates_Instance()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
SqlLocalDbProvider target = new SqlLocalDbProvider();
// Act
SqlLocalDbInstance result = target.CreateInstance();
// Assert
Assert.IsNotNull(result, "CreateInstance() returned null.");
Assert.IsNotNull(result.Name, "SqlLocalDbInstance.Name is null.");
try
{
ISqlLocalDbInstanceInfo info = result.GetInstanceInfo();
Assert.IsNotNull(info, "GetInstanceInfo() returned null.");
Assert.IsTrue(info.Exists, "ISqlLocalDbInstanceInfo.Exists is incorrect.");
Assert.IsFalse(info.IsRunning, "ISqlLocalDbInstanceInfo.IsRunning is incorrect.");
Assert.AreEqual(
new Version(target.Version).Major,
info.LocalDbVersion.Major,
"ISqlLocalDbInstanceInfo.LocalDbVersion is incorrect.");
Assert.IsTrue(Guid.TryParse(result.Name, out Guid unused), "SqlLocalDbInstance.Name is not a valid GUID.");
}
finally
{
SqlLocalDbInstance.Delete(result);
}
}
public void SqlLocalDbInstance_Share_Throws_If_SharedName_Is_Null()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
string sharedName = null;
// Act and Assert
throw ErrorAssert.Throws <ArgumentNullException>(
() => target.Share(sharedName),
"sharedName");
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
/// <summary>
/// Initializes a new instance of the <see cref="TemporarySqlLocalDbInstance"/> class.
/// </summary>
/// <param name="instanceName">The name of the temporary SQL LocalDB instance.</param>
/// <param name="provider">The <see cref="ISqlLocalDbProvider"/> to use to create the temporary instance.</param>
/// <param name="deleteFiles">Whether to delete the file(s) associated with the SQL LocalDB instance when deleted.</param>
/// <exception cref="ArgumentNullException">
/// <paramref name="instanceName"/> or <paramref name="provider"/> is <see langword="null"/>.
/// </exception>
public TemporarySqlLocalDbInstance(string instanceName, ISqlLocalDbProvider provider, bool deleteFiles)
{
if (instanceName == null)
{
throw new ArgumentNullException(nameof(instanceName));
}
if (provider == null)
{
throw new ArgumentNullException(nameof(provider));
}
_instance = provider.CreateInstance(instanceName);
_deleteFiles = deleteFiles;
try
{
_instance.Start();
}
catch (Exception)
{
SqlLocalDbInstance.Delete(_instance, throwIfNotFound: true, deleteFiles: _deleteFiles);
throw;
}
}
public void SqlLocalDbInstance_Constructor_If_Instance_Is_Started()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
try
{
SqlLocalDbApi.CreateInstance(instanceName);
try
{
string namedPipe = SqlLocalDbApi.StartInstance(instanceName);
// Act
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
// Assert
Assert.IsTrue(target.IsRunning, "SqlLocalDbInstance.IsRunning is incorrect.");
Assert.AreEqual(instanceName, target.Name, "SqlLocalDbInstance.Name is incorrect.");
Assert.AreEqual(namedPipe, target.NamedPipe, "SqlLocalDbInstance.NamedPipe is incorrect.");
}
finally
{
SqlLocalDbApi.StopInstance(instanceName);
}
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_Constructor_If_Instance_Is_Started()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
try
{
SqlLocalDbApi.CreateInstance(instanceName);
try
{
string namedPipe = SqlLocalDbApi.StartInstance(instanceName);
// Act
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
// Assert
Assert.IsTrue(target.IsRunning, "SqlLocalDbInstance.IsRunning is incorrect.");
Assert.AreEqual(instanceName, target.Name, "SqlLocalDbInstance.Name is incorrect.");
Assert.AreEqual(namedPipe, target.NamedPipe, "SqlLocalDbInstance.NamedPipe is incorrect.");
}
finally
{
SqlLocalDbApi.StopInstance(instanceName);
}
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_Stop_Throws_If_An_Error_Occurs()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
SqlLocalDbInstance target;
try
{
target = new SqlLocalDbInstance(instanceName);
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
// Act
SqlLocalDbException error = ErrorAssert.Throws <SqlLocalDbException>(
() => target.Stop());
// Assert
Assert.AreEqual(SqlLocalDbErrors.UnknownInstance, error.ErrorCode, "SqlLocalDbException.ErrorCode is incorrect.");
Assert.AreEqual(instanceName, error.InstanceName, "SqlLocalDbException.InstanceName is incorrect.");
throw error;
}
public void SqlLocalDbInstance_Delete_Deletes_Instance()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
Mock <ISqlLocalDbInstance> mock = new Mock <ISqlLocalDbInstance>();
mock.Setup((p) => p.Name).Returns(instanceName);
ISqlLocalDbInstanceInfo info = SqlLocalDbApi.GetInstanceInfo(instanceName);
Assert.IsNotNull(info, "SqlLocalDbApi.GetInstanceInfo() returned null.");
Assert.IsTrue(info.Exists, "ISqlLocalDbInstanceInfo.Exists is incorrect.");
ISqlLocalDbInstance instance = mock.Object;
// Act
SqlLocalDbInstance.Delete(instance);
// Assert
info = SqlLocalDbApi.GetInstanceInfo(instanceName);
Assert.IsNotNull(info, "SqlLocalDbApi.GetInstanceInfo() returned null.");
Assert.IsFalse(info.Exists, "The SQL LocalDB instance was not deleted.");
string path = Path.Combine(SqlLocalDbApi.GetInstancesFolderPath(), instanceName);
Assert.IsTrue(Directory.Exists(path), "The instance folder was deleted.");
Assert.AreNotEqual(0, Directory.GetFiles(path).Length, "The instance files were deleted.");
}
public void SqlLocalDbProvider_CreateInstance_Creates_Instance_With_Specified_Name()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
SqlLocalDbProvider target = new SqlLocalDbProvider();
string instanceName = Guid.NewGuid().ToString();
// Act
SqlLocalDbInstance result = target.CreateInstance(instanceName);
// Assert
Assert.IsNotNull(result, "CreateInstance() returned null.");
Assert.AreEqual(instanceName, result.Name, "SqlLocalDbInstance.Name is incorrect.");
try
{
ISqlLocalDbInstanceInfo info = result.GetInstanceInfo();
Assert.IsNotNull(info, "GetInstanceInfo() returned null.");
Assert.IsTrue(info.Exists, "ISqlLocalDbInstanceInfo.Exists is incorrect.");
Assert.IsFalse(info.IsRunning, "ISqlLocalDbInstanceInfo.IsRunning is incorrect.");
Assert.AreEqual(
new Version(target.Version).Major,
info.LocalDbVersion.Major,
"ISqlLocalDbInstanceInfo.LocalDbVersion is incorrect.");
}
finally
{
SqlLocalDbInstance.Delete(result);
}
}
public void SqlLocalDbProvider_As_ISqlLocalDbFactory_CreateInstance_Creates_Instance()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
ISqlLocalDbProvider target = new SqlLocalDbProvider();
string instanceName = Guid.NewGuid().ToString();
// Act
ISqlLocalDbInstance result = target.CreateInstance(instanceName);
// Assert
Assert.IsNotNull(result, "CreateInstance() returned null.");
Assert.AreEqual(instanceName, result.Name, "SqlLocalDbInstance.Name is incorrect.");
try
{
ISqlLocalDbInstanceInfo info = result.GetInstanceInfo();
Assert.IsTrue(info.Exists, "ISqlLocalDbInstanceInfo.Exists is incorrect.");
Assert.IsFalse(info.IsRunning, "ISqlLocalDbInstanceInfo.IsRunning is incorrect.");
Assert.IsTrue(Guid.TryParse(result.Name, out Guid unused), "SqlLocalDbInstance.Name is not a valid GUID.");
}
finally
{
SqlLocalDbInstance.Delete(result);
}
}
public void SqlLocalDbInstance_Delete_If_SqlLocalDbApi_AutomaticallyDeleteInstanceFiles_Is_True()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
Helpers.InvokeInNewAppDomain(
() =>
{
SqlLocalDbApi.AutomaticallyDeleteInstanceFiles = true;
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
Mock <ISqlLocalDbInstance> mock = new Mock <ISqlLocalDbInstance>();
mock.Setup((p) => p.Name).Returns(instanceName);
ISqlLocalDbInstanceInfo info = SqlLocalDbApi.GetInstanceInfo(instanceName);
Assert.IsNotNull(info, "SqlLocalDbApi.GetInstanceInfo() returned null.");
Assert.IsTrue(info.Exists, "ISqlLocalDbInstanceInfo.Exists is incorrect.");
ISqlLocalDbInstance instance = mock.Object;
// Act
SqlLocalDbInstance.Delete(instance);
// Assert
info = SqlLocalDbApi.GetInstanceInfo(instanceName);
Assert.IsNotNull(info, "SqlLocalDbApi.GetInstanceInfo() returned null.");
Assert.IsFalse(info.Exists, "The SQL LocalDB instance was not deleted.");
string path = Path.Combine(SqlLocalDbApi.GetInstancesFolderPath(), instanceName);
Assert.IsFalse(Directory.Exists(path), "The instance folder was not deleted.");
});
}
public void SqlLocalDbInstance_Share_Throws_If_SharedName_Is_Invalid()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
string sharedName = "\\\\";
SqlLocalDbApi.CreateInstance(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
// Act
SqlLocalDbException error = ErrorAssert.Throws <SqlLocalDbException>(
() => target.Share(sharedName));
// Assert
Assert.AreEqual(SqlLocalDbErrors.InvalidInstanceName, error.ErrorCode, "SqlLocalDbException.ErrorCode is incorrect.");
Assert.AreEqual(instanceName, error.InstanceName, "SqlLocalDbException.InstanceName is incorrect.");
throw error;
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_Delete_Throws_If_Instance_Is_Null()
{
// Arrange
ISqlLocalDbInstance instance = null;
// Act and Assert
throw ErrorAssert.Throws <ArgumentNullException>(
() => SqlLocalDbInstance.Delete(instance),
"instance");
}
public void SqlLocalDbInstance_CreateConnection_If_Instance_Is_Started_And_Returned_ConnectionStringBuilder_Is_Null()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
var mock = new Mock <SqlLocalDbInstance>(instanceName)
{
CallBase = true,
};
mock.Setup((p) => p.CreateConnectionStringBuilder())
.Returns(null as SqlConnectionStringBuilder);
SqlLocalDbInstance target = mock.Object;
target.Start();
try
{
// Act
SqlConnection result = target.CreateConnection();
try
{
// Assert
Assert.IsNotNull(result, "CreateConnection() returned null.");
Assert.AreEqual(ConnectionState.Closed, result.State, "SqlConnection.State is incorrect.");
Assert.AreEqual(string.Empty, result.ConnectionString, "SqlConnection.ConnectionString is incorrect.");
}
finally
{
if (result != null)
{
result.Dispose();
}
}
}
finally
{
SqlLocalDbApi.StopInstance(instanceName);
}
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_Unshare_If_Instance_Is_Started()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
Helpers.EnsureUserIsAdmin();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
target.Start();
try
{
string sharedName = Guid.NewGuid().ToString();
target.Share(sharedName);
ISqlLocalDbInstanceInfo info = SqlLocalDbApi.GetInstanceInfo(instanceName);
Assert.IsNotNull(info, "SqlLocalDbApi.GetInstanceInfo() returned null.");
Assert.IsTrue(info.IsShared, "ISqlLocalDbInstanceInfo.IsShared is incorrect.");
Assert.AreEqual(sharedName, info.SharedName, "ISqlLocalDbInstanceInfo.SharedName is incorrect.");
// Act
target.Unshare();
// Assert
info = SqlLocalDbApi.GetInstanceInfo(instanceName);
Assert.IsNotNull(info, "SqlLocalDbApi.GetInstanceInfo() returned null.");
Assert.IsFalse(info.IsShared, "ISqlLocalDbInstanceInfo.IsShared is incorrect.");
Assert.AreEqual(string.Empty, info.SharedName, "ISqlLocalDbInstanceInfo.SharedName is incorrect.");
}
finally
{
SqlLocalDbApi.StopInstance(instanceName);
}
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_Stop_Stops_Instance()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
target.Start();
ISqlLocalDbInstanceInfo info = SqlLocalDbApi.GetInstanceInfo(instanceName);
Assert.IsNotNull(info, "SqlLocalDbApi.GetInstanceInfo() returned null.");
Assert.IsTrue(info.IsRunning, "The SQL LocalDB instance was not started.");
Assert.IsTrue(target.IsRunning, "SqlLocalDbInstance.IsRunning is incorrect.");
Assert.AreNotEqual(string.Empty, target.NamedPipe, "SqlLocalDbInstance.NamedPipe is incorrect.");
// Act
target.Stop();
try
{
// Assert
info = SqlLocalDbApi.GetInstanceInfo(instanceName);
Assert.IsNotNull(info, "SqlLocalDbApi.GetInstanceInfo() returned null.");
Assert.IsFalse(info.IsRunning, "ISqlLocalDbInstanceInfo.IsRunning is incorrect.");
Assert.IsFalse(target.IsRunning, "SqlLocalDbInstance.IsRunning is incorrect.");
Assert.AreEqual(string.Empty, target.NamedPipe, "SqlLocalDbInstance.NamedPipe is incorrect.");
}
finally
{
SqlLocalDbApi.StopInstance(instanceName);
}
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_CreateConnection_If_Instance_Is_Started()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
target.Start();
try
{
// Act
SqlConnection result = target.CreateConnection();
try
{
// Assert
Assert.IsNotNull(result, "CreateConnection() returned null.");
Assert.AreEqual(ConnectionState.Closed, result.State, "SqlConnection.State is incorrect.");
StringAssert.Contains(result.ConnectionString, target.NamedPipe, "SqlConnection.ConnectionString is incorrect.");
}
finally
{
if (result != null)
{
result.Dispose();
}
}
}
finally
{
SqlLocalDbApi.StopInstance(instanceName);
}
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_CreateConnectionStringBuilder_Throws_If_Instance_Not_Started()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
// Act and Assert
throw ErrorAssert.Throws <InvalidOperationException>(
() => target.CreateConnectionStringBuilder());
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_Delete_Throws_If_Instance_Is_Invalid()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
const string InstanceName = "\\\\";
Mock <ISqlLocalDbInstance> mock = new Mock <ISqlLocalDbInstance>();
mock.Setup((p) => p.Name).Returns(InstanceName);
ISqlLocalDbInstance instance = mock.Object;
// Act
SqlLocalDbException error = ErrorAssert.Throws <SqlLocalDbException>(
() => SqlLocalDbInstance.Delete(instance));
// Assert
Assert.AreEqual(SqlLocalDbErrors.InvalidInstanceName, error.ErrorCode, "SqlLocalDbException.ErrorCode is incorrect.");
Assert.AreEqual(InstanceName, error.InstanceName, "SqlLocalDbException.InstanceName is incorrect.");
throw error;
}
/// <summary>
/// Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
/// </summary>
/// <param name="disposing">
/// <see langword="true" /> to release both managed and unmanaged resources;
/// <see langword="false" /> to release only unmanaged resources.
/// </param>
protected virtual void Dispose(bool disposing)
{
if (!_disposed)
{
if (_instance != null)
{
try
{
_instance.Stop();
}
catch (SqlLocalDbException ex)
{
// Ignore the exception if we could not stop the instance
// because it does not exist, otherwise log the error.
if (ex.ErrorCode != SqlLocalDbErrors.UnknownInstance)
{
Logger.Error(Logger.TraceEvent.StopFailed, SR.TemporarySqlLocalDbInstance_StopFailedFormat, _instance.Name, ex.ErrorCode);
}
}
try
{
SqlLocalDbInstance.Delete(_instance, throwIfNotFound: false, deleteFiles: _deleteFiles);
}
catch (SqlLocalDbException ex)
{
// Ignore the exception if we could not delete the instance because it was in use
if (ex.ErrorCode != SqlLocalDbErrors.InstanceBusy)
{
Logger.Error(Logger.TraceEvent.DeleteFailed, SR.TemporarySqlLocalDbInstance_DeleteFailedFormat, _instance.Name, ex.ErrorCode);
}
}
}
_disposed = true;
}
}
public void SqlLocalDbInstance_GetInstanceInfo_Returns_Information_For_The_Specified_Instance()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
ISqlLocalDbInstanceInfo expected = SqlLocalDbApi.GetInstanceInfo(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
// Act
ISqlLocalDbInstanceInfo result = target.GetInstanceInfo();
// Assert
Assert.IsNotNull(result, "GetInstanceInfo() returned null.");
Assert.AreEqual(expected.ConfigurationCorrupt, result.ConfigurationCorrupt, "ISqlLocalDbInstanceInfo. is incorrect.");
Assert.AreEqual(expected.Exists, result.Exists, "ISqlLocalDbInstanceInfo.Exists is incorrect.");
Assert.AreEqual(expected.IsAutomatic, result.IsAutomatic, "ISqlLocalDbInstanceInfo.IsAutomatic is incorrect.");
Assert.AreEqual(expected.IsRunning, result.IsRunning, "ISqlLocalDbInstanceInfo.IsRunning is incorrect.");
Assert.AreEqual(expected.IsShared, result.IsShared, "ISqlLocalDbInstanceInfo.IsShared is incorrect.");
Assert.AreEqual(expected.LastStartTimeUtc, result.LastStartTimeUtc, "ISqlLocalDbInstanceInfo.LastStartTimeUtc is incorrect.");
Assert.AreEqual(expected.LocalDbVersion, result.LocalDbVersion, "ISqlLocalDbInstanceInfo.LocalDbVersion is incorrect.");
Assert.AreEqual(expected.Name, result.Name, "ISqlLocalDbInstanceInfo.Name is incorrect.");
Assert.AreEqual(expected.NamedPipe, result.NamedPipe, "ISqlLocalDbInstanceInfo.NamedPipe is incorrect.");
Assert.AreEqual(expected.OwnerSid, result.OwnerSid, "ISqlLocalDbInstanceInfo.OwnerSid is incorrect.");
Assert.AreEqual(expected.SharedName, result.SharedName, "ISqlLocalDbInstanceInfo.SharedName is incorrect.");
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_Constructor_Throws_If_Instance_Not_Started()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
// Act
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
// Assert
Assert.IsFalse(target.IsRunning, "SqlLocalDbInstance.IsRunning is incorrect.");
Assert.AreEqual(instanceName, target.Name, "SqlLocalDbInstance.Name is incorrect.");
Assert.AreEqual(string.Empty, target.NamedPipe, "SqlLocalDbInstance.NamedPipe is incorrect.");
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_Constructor_Throws_If_Instance_Not_Started()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
// Act
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
// Assert
Assert.IsFalse(target.IsRunning, "SqlLocalDbInstance.IsRunning is incorrect.");
Assert.AreEqual(instanceName, target.Name, "SqlLocalDbInstance.Name is incorrect.");
Assert.AreEqual(string.Empty, target.NamedPipe, "SqlLocalDbInstance.NamedPipe is incorrect.");
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_CreateConnectionStringBuilder_Throws_If_Instance_Not_Started()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
// Act and Assert
throw ErrorAssert.Throws<InvalidOperationException>(
() => target.CreateConnectionStringBuilder());
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_CreateConnection_If_Instance_Is_Started()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
target.Start();
try
{
// Act
SqlConnection result = target.CreateConnection();
try
{
// Assert
Assert.IsNotNull(result, "CreateConnection() returned null.");
Assert.AreEqual(ConnectionState.Closed, result.State, "SqlConnection.State is incorrect.");
StringAssert.Contains(result.ConnectionString, target.NamedPipe, "SqlConnection.ConnectionString is incorrect.");
}
finally
{
if (result != null)
{
result.Dispose();
}
}
}
finally
{
SqlLocalDbApi.StopInstance(instanceName);
}
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_GetInstanceInfo_Returns_Information_For_The_Specified_Instance()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
ISqlLocalDbInstanceInfo expected = SqlLocalDbApi.GetInstanceInfo(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
// Act
ISqlLocalDbInstanceInfo result = target.GetInstanceInfo();
// Assert
Assert.IsNotNull(result, "GetInstanceInfo() returned null.");
Assert.AreEqual(expected.ConfigurationCorrupt, result.ConfigurationCorrupt, "ISqlLocalDbInstanceInfo. is incorrect.");
Assert.AreEqual(expected.Exists, result.Exists, "ISqlLocalDbInstanceInfo.Exists is incorrect.");
Assert.AreEqual(expected.IsAutomatic, result.IsAutomatic, "ISqlLocalDbInstanceInfo.IsAutomatic is incorrect.");
Assert.AreEqual(expected.IsRunning, result.IsRunning, "ISqlLocalDbInstanceInfo.IsRunning is incorrect.");
Assert.AreEqual(expected.IsShared, result.IsShared, "ISqlLocalDbInstanceInfo.IsShared is incorrect.");
Assert.AreEqual(expected.LastStartTimeUtc, result.LastStartTimeUtc, "ISqlLocalDbInstanceInfo.LastStartTimeUtc is incorrect.");
Assert.AreEqual(expected.LocalDbVersion, result.LocalDbVersion, "ISqlLocalDbInstanceInfo.LocalDbVersion is incorrect.");
Assert.AreEqual(expected.Name, result.Name, "ISqlLocalDbInstanceInfo.Name is incorrect.");
Assert.AreEqual(expected.NamedPipe, result.NamedPipe, "ISqlLocalDbInstanceInfo.NamedPipe is incorrect.");
Assert.AreEqual(expected.OwnerSid, result.OwnerSid, "ISqlLocalDbInstanceInfo.OwnerSid is incorrect.");
Assert.AreEqual(expected.SharedName, result.SharedName, "ISqlLocalDbInstanceInfo.SharedName is incorrect.");
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_Share_Throws_If_SharedName_Is_Invalid()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
string sharedName = "\\\\";
SqlLocalDbApi.CreateInstance(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
// Act
SqlLocalDbException error = ErrorAssert.Throws<SqlLocalDbException>(
() => target.Share(sharedName));
// Assert
Assert.AreEqual(SqlLocalDbErrors.InvalidInstanceName, error.ErrorCode, "SqlLocalDbException.ErrorCode is incorrect.");
Assert.AreEqual(instanceName, error.InstanceName, "SqlLocalDbException.InstanceName is incorrect.");
throw error;
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_Share_Throws_If_SharedName_Is_Null()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
string sharedName = null;
// Act and Assert
throw ErrorAssert.Throws<ArgumentNullException>(
() => target.Share(sharedName),
"sharedName");
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_Stop_Stops_Instance()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
target.Start();
ISqlLocalDbInstanceInfo info = SqlLocalDbApi.GetInstanceInfo(instanceName);
Assert.IsNotNull(info, "SqlLocalDbApi.GetInstanceInfo() returned null.");
Assert.IsTrue(info.IsRunning, "The SQL LocalDB instance was not started.");
Assert.IsTrue(target.IsRunning, "SqlLocalDbInstance.IsRunning is incorrect.");
Assert.AreNotEqual(string.Empty, target.NamedPipe, "SqlLocalDbInstance.NamedPipe is incorrect.");
// Act
target.Stop();
try
{
// Assert
info = SqlLocalDbApi.GetInstanceInfo(instanceName);
Assert.IsNotNull(info, "SqlLocalDbApi.GetInstanceInfo() returned null.");
Assert.IsFalse(info.IsRunning, "ISqlLocalDbInstanceInfo.IsRunning is incorrect.");
Assert.IsFalse(target.IsRunning, "SqlLocalDbInstance.IsRunning is incorrect.");
Assert.AreEqual(string.Empty, target.NamedPipe, "SqlLocalDbInstance.NamedPipe is incorrect.");
}
finally
{
SqlLocalDbApi.StopInstance(instanceName);
}
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_Unshare_If_Instance_Is_Started()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
Helpers.EnsureUserIsAdmin();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
target.Start();
try
{
string sharedName = Guid.NewGuid().ToString();
target.Share(sharedName);
ISqlLocalDbInstanceInfo info = SqlLocalDbApi.GetInstanceInfo(instanceName);
Assert.IsNotNull(info, "SqlLocalDbApi.GetInstanceInfo() returned null.");
Assert.IsTrue(info.IsShared, "ISqlLocalDbInstanceInfo.IsShared is incorrect.");
Assert.AreEqual(sharedName, info.SharedName, "ISqlLocalDbInstanceInfo.SharedName is incorrect.");
// Act
target.Unshare();
// Assert
info = SqlLocalDbApi.GetInstanceInfo(instanceName);
Assert.IsNotNull(info, "SqlLocalDbApi.GetInstanceInfo() returned null.");
Assert.IsFalse(info.IsShared, "ISqlLocalDbInstanceInfo.IsShared is incorrect.");
Assert.AreEqual(string.Empty, info.SharedName, "ISqlLocalDbInstanceInfo.SharedName is incorrect.");
}
finally
{
SqlLocalDbApi.StopInstance(instanceName);
}
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_Unshare_Throws_If_An_Error_Occurs()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
target.Start();
try
{
// Act
SqlLocalDbException error = ErrorAssert.Throws<SqlLocalDbException>(
() => target.Unshare());
// Assert
Assert.AreEqual(SqlLocalDbErrors.InstanceNotShared, error.ErrorCode, "SqlLocalDbException.ErrorCode is incorrect.");
Assert.AreEqual(instanceName, error.InstanceName, "SqlLocalDbException.InstanceName is incorrect.");
throw error;
}
finally
{
SqlLocalDbApi.StopInstance(instanceName);
}
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
public void SqlLocalDbInstance_CreateConnectionStringBuilder_If_Instance_Started()
{
// Arrange
Helpers.EnsureLocalDBInstalled();
string instanceName = Guid.NewGuid().ToString();
SqlLocalDbApi.CreateInstance(instanceName);
try
{
SqlLocalDbInstance target = new SqlLocalDbInstance(instanceName);
target.Start();
try
{
// Act
SqlConnectionStringBuilder result = target.CreateConnectionStringBuilder();
// Assert
Assert.IsNotNull(result, "CreateConnection() returned null.");
StringAssert.Contains(result.ConnectionString, target.NamedPipe, "SqlConnection.ConnectionString is incorrect.");
}
finally
{
SqlLocalDbApi.StopInstance(instanceName);
}
}
finally
{
SqlLocalDbApi.DeleteInstance(instanceName);
}
}
