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"); }