public static DataTable GetTable(string sql) { IDBConnection conn = (IDBConnection) new DBConnection(); using (var connection = new NpgsqlConnection(conn.GetDBConnectionParameters())) { connection.Open(); DataSet dataSet = new DataSet(); NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter(sql, connection); dataSet.Reset(); dataAdapter.Fill(dataSet); return(dataSet.Tables[0]); } }