override public DataSet doSelect(string query,DataSet ds) { Open(); NpgsqlConnection conn = ( (NpgsqlConnection) dbCon ); NpgsqlDataAdapter da = new NpgsqlDataAdapter(query,conn); query = query.Trim(); if (query.StartsWith(";")) query = query.Substring(1); string[] sqls = query.Split(';'); int counter = 0; for (int i =0; i< sqls.Length;i++) { da = new NpgsqlDataAdapter(sqls[i],conn); try { da.Fill(ds,"tbl"+counter++); } catch(Exception ex) { Close(); Logger.Log("Error executing query:\r\n" + query, LogLevel.Trace); throw new Exception("Error executing query:\r\n" + query + "\n\r" +ex.Message,ex.InnerException); } da.Dispose(); } Close(); return ds; }