public void CreateTest() { string connStr = @"Data Source=vish-laptop\sqlexpress2008;Initial Catalog=VishDB;Integrated Security=True;Connection Timeout=180;"; target = new SQL2008Database(connStr); Assert.IsNotNull("Failed to create the connection to the sql server 2008 connection."); target.Dispose(); }
public void CreateTest1(string serverName, string databaseName) { ServerConnection conn = new ServerConnection(serverName); SQL2008Server server = new SQL2008Server(conn); target = new SQL2008Database(server, databaseName); Assert.IsNotNull(target, "Failed to create SQL2008Database"); target.Dispose(); }
public void CreateDeleteTableTest(string serverName, string databaseName, string tableName) { ServerConnection conn = new ServerConnection(serverName); SQL2008Server server = new SQL2008Server(conn); target = new SQL2008Database(server, databaseName); Assert.IsNotNull(target, "Failed to create SQL2008Database"); target.CreateTable(tableName, new List <DataColumn>() { new DataColumn("ID", typeof(int)) }.GetEnumerator()); target.DeleteTable(tableName); target.Dispose(); }
public void ContainsTableTest(string serverName, string databaseName, string tableName) { ServerConnection conn = new ServerConnection(serverName); SQL2008Server server = new SQL2008Server(conn); target = new SQL2008Database(server, databaseName); Assert.IsNotNull(target, "Failed to create SQL2008Database"); target.CreateTable(tableName, new List <DataColumn>() { new DataColumn("ID", typeof(int)) }.GetEnumerator()); Assert.AreEqual(true, target.ContainsTable(tableName), "Unable to find table '" + tableName + "' in the database '" + databaseName + "'."); target.DeleteTable(tableName); target.Dispose(); }