public void ConnectionStringBuilder_FormatConnectionString_MasterForLocalDB()
{
var builder = new ConnectionStringBuilder();
var connectionString = @"Data Source=(LocalDB)\mssqllocaldb;AttachDBFileName=c:\Path\To\Database\WickeFlame.mdf;Initial Catalog=WickeFlame;Integrated Security=True;";
connectionString = builder.SetDatabase("Master", connectionString);
var master = builder.FormatConnectionString(connectionString);
Assert.AreEqual(master, @"Data Source=(LocalDB)\mssqllocaldb;Initial Catalog=Master;Integrated Security=True;");
}
public void ConnectionStringBuilder_SetDatabaseFromInitialCatalogTest()
{
var builder = new ConnectionStringBuilder();
var connectionString = "data source=.;Initial Catalog =TempDB;persist security info=False;user id=sa";
connectionString = builder.SetDatabase("WarriorDB", connectionString);
Assert.AreEqual(connectionString, "data source=.;Initial Catalog=WarriorDB;persist security info=False;user id=sa");
connectionString = "data source=.;Initial Catalog=TempDB;persist security info=False;user id=sa";
connectionString = builder.SetDatabase("WarriorDB", connectionString);
Assert.AreEqual(connectionString, "data source=.;Initial Catalog=WarriorDB;persist security info=False;user id=sa");
connectionString = "data source=.;initial catalog=TempDB;persist security info=False;user id=sa";
connectionString = builder.SetDatabase("WarriorDB", connectionString);
Assert.AreEqual(connectionString, "data source=.;initial catalog=WarriorDB;persist security info=False;user id=sa");
connectionString = "data source=.;initial catalog=TempDB;persist security info=False;user id=sa";
connectionString = builder.SetDatabase("WarriorDB", connectionString);
Assert.AreEqual(connectionString, "data source=.;initial catalog=WarriorDB;persist security info=False;user id=sa");
connectionString = "data source=.;initial catalog= TempDB;persist security info=False;user id=sa";
connectionString = builder.SetDatabase("WarriorDB", connectionString);
Assert.AreEqual(connectionString, "data source=.;initial catalog=WarriorDB;persist security info=False;user id=sa");
}
public void ConnectionStringBuilder_SetDatabaseFromDataSourceTest()
{
var builder = new ConnectionStringBuilder();
var connectionString = "Data Source =TempDB.db";
connectionString = builder.SetDatabase("WarriorDB.db", connectionString);
Assert.AreEqual(connectionString, "Data Source=WarriorDB.db");
connectionString = "Data Source=TempDB.db";
connectionString = builder.SetDatabase("WarriorDB.db", connectionString);
Assert.AreEqual(connectionString, "Data Source=WarriorDB.db");
connectionString = "data source =TempDB.db";
connectionString = builder.SetDatabase("WarriorDB.db", connectionString);
Assert.AreEqual(connectionString, "data source=WarriorDB.db");
connectionString = "data source=TempDB.db";
connectionString = builder.SetDatabase("WarriorDB.db", connectionString);
Assert.AreEqual(connectionString, "data source=WarriorDB.db");
connectionString = "data source= TempDB.db";
connectionString = builder.SetDatabase("WarriorDB.db", connectionString);
Assert.AreEqual(connectionString, "data source=WarriorDB.db");
connectionString = "data source=TempDB.db;";
connectionString = builder.SetDatabase("WarriorDB.db", connectionString);
Assert.AreEqual(connectionString, "data source=WarriorDB.db;");
connectionString = @"Data Source=c:\TempDB.db;Version=3;New=True;";
connectionString = builder.SetDatabase(@"c:\WarriorDB.db", connectionString);
Assert.AreEqual(connectionString, @"Data Source=c:\WarriorDB.db;Version=3;New=True;");
}
