public void TestCreateParameterNameGenerator() { //---------------Set up test pack------------------- IDatabaseConnection databaseConnection = new DatabaseConnectionAccess("", ""); //---------------Assert PreConditions--------------- //---------------Execute Test ---------------------- IParameterNameGenerator generator = databaseConnection.CreateParameterNameGenerator(); //---------------Test Result ----------------------- Assert.AreEqual("@", generator.PrefixCharacter); //---------------Tear Down ------------------------- }
public void Test_IsolationLevel_Access() { //---------------Execute Test ---------------------- DatabaseConnection conn = new DatabaseConnectionAccess("System.Data", "System.Data.OleDb.OleDbConnection"); //---------------Test Result ----------------------- Assert.AreEqual(IsolationLevel.ReadUncommitted, conn.IsolationLevel); }
public void Test_CreateSqlFormatter_AlternateConstructor_Access2007() { //---------------Set up test pack------------------- string connectionString = new DatabaseConfig(DatabaseConfig.Access2007, "test", "test", "test", "test", "1000").GetConnectionString (); IDatabaseConnection dbConn = new DatabaseConnectionAccess ("System.Data", "System.Data.SqlClient.SqlConnection", connectionString); //---------------Assert Precondition---------------- //---------------Execute Test ---------------------- ISqlFormatter defaultSqlFormatter = dbConn.SqlFormatter; //---------------Test Result ----------------------- Assert.IsInstanceOf(typeof(SqlFormatterForAccess), defaultSqlFormatter); SqlFormatter sqlFormatter = (SqlFormatter)defaultSqlFormatter; Assert.IsNotNull(sqlFormatter); Assert.AreEqual("[", sqlFormatter.LeftFieldDelimiter); Assert.AreEqual("]", sqlFormatter.RightFieldDelimiter); Assert.AreEqual("TOP", sqlFormatter.LimitClauseAtBeginning); Assert.AreEqual("", sqlFormatter.LimitClauseAtEnd); Assert.AreEqual(sqlFormatter.LeftFieldDelimiter, dbConn.LeftFieldDelimiter); Assert.AreEqual(sqlFormatter.RightFieldDelimiter, dbConn.RightFieldDelimiter); // StringAssert.Contains("TOP", dbConn.GetLimitClauseForBeginning(1)); // Assert.AreEqual("", dbConn.GetLimitClauseForEnd(1)); }
public void Test_CreateDatabaseConnection_Access() { DatabaseConnection conn = new DatabaseConnectionAccess("System.Data", "System.Data.OleDb.OleDbConnection"); conn.ConnectionString = new DatabaseConfig(DatabaseConfig.Access, "test", "test", "test", "test", "1000").GetConnectionString(); Assert.AreEqual ("System.Data.OleDb", conn.TestConnection.GetType().Namespace, "Namespace of Access connection is wrong."); }