Пример #1
0
 /// <summary>
 /// Drops the tables with the given table names.
 /// <para/>
 /// SQL query Example: <para/>
 /// DROP TABLE table1
 /// </summary>
 /// <param name="tableNames">A list of table names to delete.</param>
 public override void DropTables(List <string> tableNames)
 {
     foreach (var tableName in tableNames)
     {
         SQLQueryBuilder sqb = new SQLQueryBuilder();
         sqb.DropTable().AddValue(tableName);
         CommitQuery(sqb.ToString());
     }
 }
 /// <summary>
 /// Drops the tables with the given table names.
 /// DROP TABLE table1
 /// </summary>
 /// <param name="tableNames">A list of table names to delete.</param>
 public override void DropTables(List <string> tableNames)
 {
     try
     {
         List <string> tableQueries = new List <string>();
         foreach (var tableName in tableNames)
         {
             SQLQueryBuilder sqb = new SQLQueryBuilder();
             sqb.DropTable().AddValue(tableName);
             tableQueries.Add(sqb.ToString());
         }
         CommitBatchQuery(tableQueries);
     }
     catch (Exception e)
     {
         throw e;
     }
 }