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]);
}
}
