public void Keys ()
{
OdbcConnectionStringBuilder builder;
ICollection keys;
object [] keylist;
builder = new OdbcConnectionStringBuilder ();
keys = builder.Keys;
Assert.IsNotNull (keys, "#A1");
Assert.AreEqual (2, keys.Count, "#A2");
keylist = new object [keys.Count];
keys.CopyTo (keylist, 0);
Assert.AreEqual (2, keylist.Length, "#A3");
Assert.AreEqual ("Dsn", keylist [0], "#A4");
Assert.AreEqual ("Driver", keylist [1], "#A5");
builder = new OdbcConnectionStringBuilder ("Database=test;Driver=SQL Server;dsn=AdventureWorks");
keys = builder.Keys;
Assert.IsNotNull (keys, "#B1");
Assert.AreEqual (3, keys.Count, "#B2");
keylist = new object [keys.Count];
keys.CopyTo (keylist, 0);
Assert.AreEqual (3, keylist.Length, "#B3");
Assert.AreEqual ("Dsn", keylist [0], "#B4");
Assert.AreEqual ("Driver", keylist [1], "#B5");
Assert.AreEqual ("database", keylist [2], "#B6");
builder = new OdbcConnectionStringBuilder ("Driver=SQL Server;dsn=AdventureWorks;Database=test;Port=");
keys = builder.Keys;
Assert.IsNotNull (keys, "#C1");
Assert.AreEqual (3, keys.Count, "#C2");
keylist = new object [keys.Count];
keys.CopyTo (keylist, 0);
Assert.AreEqual (3, keylist.Length, "#C3");
Assert.AreEqual ("Dsn", keylist [0], "#C4");
Assert.AreEqual ("Driver", keylist [1], "#C5");
Assert.AreEqual ("database", keylist [2], "#C6");
builder = new OdbcConnectionStringBuilder ();
builder ["DataBase"] = "test";
builder.Driver = "SQL Server";
builder ["User"] = "******";
builder ["porT"] = "25";
keys = builder.Keys;
Assert.IsNotNull (keys, "#D1");
Assert.AreEqual (5, keys.Count, "#D2");
keylist = new object [keys.Count];
keys.CopyTo (keylist, 0);
Assert.AreEqual (5, keylist.Length, "#D3");
Assert.AreEqual ("Dsn", keylist [0], "#D4");
Assert.AreEqual ("Driver", keylist [1], "#D5");
Assert.AreEqual ("DataBase", keylist [2], "#D6");
Assert.AreEqual ("User", keylist [3], "#D7");
Assert.AreEqual ("porT", keylist [4], "#D8");
builder.Clear ();
keys = builder.Keys;
Assert.IsNotNull (keys, "#E1");
Assert.AreEqual (2, keys.Count, "#E2");
keylist = new object [keys.Count];
keys.CopyTo (keylist, 0);
Assert.AreEqual (2, keylist.Length, "#E3");
Assert.AreEqual ("Dsn", keylist [0], "#E4");
Assert.AreEqual ("Driver", keylist [1], "#E5");
}
public void Driver ()
{
OdbcConnectionStringBuilder builder = new OdbcConnectionStringBuilder ();
Assert.IsTrue (builder.ContainsKey ("Driver"), "#A1");
Assert.AreEqual (string.Empty, builder ["Driver"], "#A2");
Assert.AreEqual (string.Empty, builder.Driver, "#A3");
builder.Driver = "SQL Server";
Assert.AreEqual ("Driver={SQL Server}", builder.ConnectionString, "#B1");
Assert.IsTrue (builder.ContainsKey ("Driver"), "#B2");
Assert.AreEqual ("SQL Server", builder ["Driver"], "#B3");
Assert.AreEqual ("SQL Server", builder.Driver, "#B4");
builder.Clear ();
builder.Driver = "{SQL Server";
Assert.AreEqual ("Driver={{SQL Server}", builder.ConnectionString, "#C1");
Assert.IsTrue (builder.ContainsKey ("Driver"), "#C2");
Assert.AreEqual ("{SQL Server", builder ["Driver"], "#C3");
Assert.AreEqual ("{SQL Server", builder.Driver, "#C4");
builder.Clear ();
builder.Driver = "{SQL Server}";
Assert.AreEqual ("Driver={SQL Server}", builder.ConnectionString, "#D1");
Assert.IsTrue (builder.ContainsKey ("Driver"), "#D2");
Assert.AreEqual ("{SQL Server}", builder ["Driver"], "#D3");
Assert.AreEqual ("{SQL Server}", builder.Driver, "#D4");
builder.Clear ();
builder.Driver = string.Empty;
Assert.AreEqual ("Driver=", builder.ConnectionString, "#E1");
Assert.IsTrue (builder.ContainsKey ("Driver"), "#E2");
Assert.AreEqual (string.Empty, builder ["Driver"], "#E3");
Assert.AreEqual (string.Empty, builder.Driver, "#E4");
builder.Clear ();
builder ["Driver"] = "SQL Server";
Assert.AreEqual ("Driver={SQL Server}", builder.ConnectionString, "#F1");
Assert.IsTrue (builder.ContainsKey ("Driver"), "#F2");
Assert.AreEqual ("SQL Server", builder ["Driver"], "#F3");
Assert.AreEqual ("SQL Server", builder.Driver, "#F4");
builder.Clear ();
builder ["Driver"] = "{SQL Server";
Assert.AreEqual ("Driver={{SQL Server}", builder.ConnectionString, "#G1");
Assert.IsTrue (builder.ContainsKey ("Driver"), "#G2");
Assert.AreEqual ("{SQL Server", builder ["Driver"], "#G3");
Assert.AreEqual ("{SQL Server", builder.Driver, "#G4");
builder.Clear ();
builder ["Driver"] = "{SQL Server}";
Assert.AreEqual ("Driver={SQL Server}", builder.ConnectionString, "#H1");
Assert.IsTrue (builder.ContainsKey ("Driver"), "#H2");
Assert.AreEqual ("{SQL Server}", builder ["Driver"], "#H3");
Assert.AreEqual ("{SQL Server}", builder.Driver, "#H4");
builder.Clear ();
builder ["Driver"] = string.Empty;
Assert.AreEqual ("Driver=", builder.ConnectionString, "#I1");
Assert.IsTrue (builder.ContainsKey ("Driver"), "#I2");
Assert.AreEqual (string.Empty, builder ["Driver"], "#I3");
Assert.AreEqual (string.Empty, builder.Driver, "#I4");
}
public void Dsn ()
{
OdbcConnectionStringBuilder builder = new OdbcConnectionStringBuilder ();
Assert.IsTrue (builder.ContainsKey ("Dsn"), "#A1");
Assert.AreEqual (string.Empty, builder ["Dsn"], "#A2");
Assert.AreEqual (string.Empty, builder.Dsn, "#A3");
builder.Dsn = "myDsn";
Assert.AreEqual ("Dsn=myDsn", builder.ConnectionString, "#B1");
Assert.IsTrue (builder.ContainsKey ("Dsn"), "#B2");
Assert.AreEqual ("myDsn", builder ["Dsn"], "#B3");
Assert.AreEqual ("myDsn", builder.Dsn, "#B4");
builder.Clear ();
builder ["Dsn"] = "myDsn";
Assert.AreEqual ("Dsn=myDsn", builder.ConnectionString, "#C1");
Assert.IsTrue (builder.ContainsKey ("Dsn"), "#C2");
Assert.AreEqual ("myDsn", builder ["Dsn"], "#C3");
Assert.AreEqual ("myDsn", builder.Dsn, "#C4");
}
public void Clear ()
{
OdbcConnectionStringBuilder builder = new OdbcConnectionStringBuilder ();
builder ["Dbq"] = "C:\\Data.xls";
builder.Driver = "SQL Server";
builder.Dsn = "AdventureWorks";
builder.Add ("Port", "56");
builder.Clear ();
Assert.AreEqual (string.Empty, builder.ConnectionString, "#1");
Assert.IsFalse (builder.ContainsKey ("Dbq"), "#2");
Assert.AreEqual (string.Empty, builder.Driver, "#3");
Assert.AreEqual (string.Empty, builder.Dsn, "#4");
Assert.IsFalse (builder.ContainsKey ("Port"), "#5");
}
