In the meantime I was able to connect to the database from code with the ODP.NET Oracle driver.
Set these values at startup:
//Enter directory where you unzipped your cloud credentials
//REMARK: you can set this as long as you didn't open a connection yet. It will throw an exception
OracleConfiguration.TnsAdmin = @"<path to unzipped wallet>";
OracleConfiguration.WalletLocation = OracleConfiguration.TnsAdmin;
and then open the connection like this:
//Enter your ADB's user id, password, and net service name (a TNS name from the list of connectionstrings)
string conString = "User Id=<ADMIN>;Password=<PWD>;Data Source=<TNS_NAME>;Connection Timeout=30;";
using (var cn = new OracleConnection(conString))
Console.WriteLine("Successfully connected to Oracle Autonomous Database");
You then give it a name after 'description', like MyOracleCloudDB, and specify that as server name
We haven't tested our system on the Oracle cloud so we don't have any data regarding whether it will work (so consider it as 'not supported'). The designer doesn't have transient error recovery implemented for Oracle cloud too in the Oracle driver (something which is likely required if you want to work with a connection from on-prem to cloud databases)
I think I came very close, using the method you suggested, but I still received an error saying the connection was actively refused by the server.
Adding the mentioned IP-address to the list of allowed IP's didn't fix it.
But I think this was a server configuration issue, rather than an LLBLGen issue.
Anyway, in the meantime I switched to a PostgreSQL cloud database. Easy to setup, easy to connect to. :-)
Unfortunately not as free as the Oracle Always Free services. :-D
An alternative (if you want to go for Oracle) can be to install the free Oracle dev db locally, develop your schema/app there, and then deploy it on the cloud DB. This is usually a better option anyway as reverse engineering a relational model from a cloud database can be difficult as they're often not offering access to meta-data schemas.