public void Delete()
{
String sqlCommandText = @"
ALTER DATABASE " + _dbname + @" SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE [" + _dbname + "]";
ExecuteQuery.Execute(sqlCommandText, _connectionstring);
}
public void SeedTable(string dbname, string tablename, string Filepath, string connectionsting, int datetymetype = 105)
{
ReadXML xmlreaer = new ReadXML();
List <Dictionary <string, string> > data = xmlreaer.Read(Filepath);
CreateQuery queryobj = new CreateQuery();
string query = queryobj.create(dbname, tablename, data, connectionsting, datetymetype);
ExecuteQuery.Execute(query, connectionsting);
}
public void Run()
{
ExecuteQuery.Execute(_schema, _connectionstring);
}
