public void TestIpAddressConstructor(string ipStr)
{
var ip = IPAddress.Parse(ipStr);
var dbaInstanceParamater = new DbaInstanceParameter(ip);
Assert.AreEqual(ip.ToString(), dbaInstanceParamater.FullName);
Assert.AreEqual('[' + ip.ToString() + ']', dbaInstanceParamater.SqlFullName);
Assert.AreEqual(ip.ToString(), dbaInstanceParamater.FullSmoName);
Assert.AreEqual(ip.ToString(), dbaInstanceParamater.ToString());
Assert.AreEqual(SqlConnectionProtocol.Any, dbaInstanceParamater.NetworkProtocol);
}
public void TestLocalhost(string localhost)
{
var dbaInstanceParamater = new DbaInstanceParameter(localhost);
Assert.AreEqual(localhost, dbaInstanceParamater.FullName);
Assert.AreEqual('[' + localhost + ']', dbaInstanceParamater.SqlFullName);
Assert.AreEqual(localhost, dbaInstanceParamater.FullSmoName);
Assert.AreEqual(localhost, dbaInstanceParamater.ToString());
Assert.AreEqual(SqlConnectionProtocol.Any, dbaInstanceParamater.NetworkProtocol);
Assert.IsTrue(dbaInstanceParamater.IsLocalHost);
}
public void TestLocalDbConnectionString()
{
var dbaInstanceParamater = new DbaInstanceParameter(@"Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=aspnet-MvcMovie;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\Movies.mdf");
Assert.AreEqual("localhost", dbaInstanceParamater.ComputerName);
Assert.AreEqual("[localhost]", dbaInstanceParamater.SqlComputerName);
Assert.AreEqual(@"localhost\MSSQLLocalDB", dbaInstanceParamater.FullName);
Assert.AreEqual(@"localhost\MSSQLLocalDB", dbaInstanceParamater.FullSmoName);
Assert.AreEqual(@"localhost\MSSQLLocalDB", dbaInstanceParamater.ToString());
Assert.AreEqual(@"MSSQLLocalDB", dbaInstanceParamater.InstanceName);
Assert.AreEqual(SqlConnectionProtocol.Any, dbaInstanceParamater.NetworkProtocol);
Assert.IsTrue(dbaInstanceParamater.IsLocalHost);
Assert.IsTrue(dbaInstanceParamater.IsConnectionString);
}
