public void Test_sql_connection_string_validation()
{
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;MultipleActiveResultSets=true;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Server=.\SQLExpress;AttachDbFilename=C:\MyFolder\MyDataFile.mdf;Database=dbname;Trusted_Connection=Yes;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;Database=dbname;Trusted_Connection=Yes;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Server=(localdb)\v11.0;Integrated Security=true;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Server=(localdb)\v11.0;Integrated Security=true;AttachDbFileName=C:\MyFolder\MyData.mdf;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Server=(localdb)\MyInstance;Integrated Security=true;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Server=np:\\.\pipe\LOCALDB#F365A78E\tsql\query;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Server=(localdb)\.\MyInstanceShare;Integrated Security=true;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Data Source=myServerAddress;Failover Partner=myMirrorServerAddress;Initial Catalog=myDataBase;Integrated Security=True;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Server=myServerAddress;Database=myDataBase;Integrated Security=True;Asynchronous Processing=True;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Data Source=.\SQLExpress;Integrated Security=true;AttachDbFilename=C:\MyFolder\MyDataFile.mdf;User Instance=true;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;Packet Size=4096;"));
Assert.IsTrue(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@" Server=myServerAddress;Database=myDataBase;Trusted_Connection=True; "));
Assert.IsFalse(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"foo"));
Assert.IsFalse(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(null));
Assert.IsFalse(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@" "));
Assert.IsFalse(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(string.Empty));
Assert.IsFalse(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Server=myServerName/myInstanceName;Database=myDataBase;UserId=myUsername;Password=myPassword;"));
Assert.IsFalse(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Server=myServerName\myInstanceName;Database=myDataBase;UserId=myUsername;"));
Assert.IsFalse(SampleApplicationConfigProvider.IsValidSqlServerConnectionString(@"Server=myServerName\myInstanceName;UserId=myUsername;Password=myPassword;"));
}
