/// <summary>
/// Assembles and executes a drop table statement.
/// </summary>
private void ExecuteDropTable()
{
using (var provider = new SqliteDatabaseProvider())
{
var deleteTempTableQuery = new SqlQuery("DROP TABLE IF EXISTS {0};", this.Table.TableName);
provider.ExecuteNonQuery(this.connection, deleteTempTableQuery);
}
}
/// <summary>
/// Assembles and executes a create table statement.
/// </summary>
private void ExecuteCreateTable()
{
const string CreateTempTable = "CREATE TEMP TABLE {0} ({1});";
string columnString = string.Join(", ", this.Table.Columns.Select(column => FormatColumn(column)));
using (var provider = new SqliteDatabaseProvider())
{
var deleteTempTableQuery = new SqlQuery(CreateTempTable, this.Table.TableName, columnString);
provider.ExecuteNonQuery(this.connection, deleteTempTableQuery);
}
}
/// <summary>
/// Executes a query string in the database.
/// </summary>
/// <param name="query">The query string to be executed.</param>
private void ExecuteQuery(string query)
{
var provider = new SqliteDatabaseProvider();
provider.ExecuteNonQuery(this.DatabaseConnection, new SqlQuery(query));
}
