public ExecutionResponse ExecuteNonQuery(string commandText)
{
ExecutionResponse response = new ExecutionResponse();
try
{
this.EnsureDbOpen();
response.NumberOfRows = this.SQLiteConnection.Execute(commandText);
response.State = DbResponseState.Success;
}
catch (Exception ex)
{
response.State = DbResponseState.Failure;
response.ErrorResponse = ex;
throw;
}
finally
{
this.SQLiteConnection.Close();
}
return(response);
}
public ExecutionResponse CreateTable(string createStatement)
{
ExecutionResponse response = new ExecutionResponse();
response = this.ExecuteNonQuery(createStatement);
return(response);
}