Thank you very much , I have changed the database and getting more progress in Denodo thanks for the support ,
This is the code that Im using to connect denodo platform :
string query = "SELECT * FROM car";
string connectionString = "Server=localhost;Port=9996;Username=admin;Password=admin;Database=new_sampledb;Timeout=30;CommandTimeout=30";
using (NpgsqlConnection connection = new NpgsqlConnection(connectionString))
using (NpgsqlCommand command = new NpgsqlCommand(query, connection))
When I open the connection it shows an exception that shown below, Could you please help me to undestand what is wrong in the above code?
: View 'pg_type' not found
DETAIL: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.