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