/// <summary> /// /// </summary> /// <param name="db"> /// A <see cref="Database"/> /// </param> /// <param name="queryText"> /// A <see cref="System.String"/> /// </param> /// <param name="queryParams"> /// A <see cref="System.String[]"/> /// </param> /// <returns> /// A <see cref="IResultSet"/> /// </returns> public override IResultSet ExecuteSQLQuery(Database db, string queryText, string[] queryParams) { IResultSet resultSet = null; if (db != null) { DbConnection connection = GetConnection(db.Name); if (connection != null) { string queryString = queryText; try { if (queryParams != null) { queryString = String.Format(queryString, queryParams); } DataSet ds = new DataSet(); SqliteDataAdapter adapter = new SqliteDataAdapter(queryString, (SqliteConnection)connection); adapter.Fill(ds); resultSet = new ResultSet(ds); } catch (Exception e) { SystemLogger.Log(SystemLogger.Module.PLATFORM, "Exception replacement strings on statement.", e); } } else { SystemLogger.Log(SystemLogger.Module.PLATFORM, "SQLiteConnection not found for database name: " + db.Name); } } else { SystemLogger.Log(SystemLogger.Module.PLATFORM, "Provided database is null"); } return resultSet; }
/// <summary> /// Executes a SQL Query that should return data. /// </summary> /// <param name="db">Database reference.</param> /// <param name="queryText">Query to be executed.</param> /// <param name="queryParams">Values to be replaced on query string.</param> /// <returns>Result set.</returns> public override IResultSet ExecuteSQLQuery(Database db, string queryText, string[] queryParams) { IResultSet resultSet = null; if (db != null) { DbConnection connection = GetConnection(db.Name); if (connection != null) { string queryString = queryText; try { if (queryParams != null) { queryString = String.Format(queryString, queryParams); } DataSet ds = new DataSet(); SQLiteDataAdapter adapter = new SQLiteDataAdapter(queryString, (SQLiteConnection)connection); adapter.Fill(ds); resultSet = new ResultSet(ds); } catch (Exception e) { #if DEBUG Console.WriteLine("Exception replacement strings on statement: " + e.Message); #endif } } else { #if DEBUG Console.WriteLine("SQLiteConnection not found for database name: " + db.Name); #endif } } else { #if DEBUG Console.WriteLine("Provided database is null"); #endif } return resultSet; }