Devart is glad to announce the release of dotConnect for Oracle 9.12, Devart ADO.NET data provider for Oracle with support for Entity Framework, Entity Framework Core, LinqConnect (LINQ to Oracle), and NHibernate. The new release contains support of SSH connections in the Direct mode. Now you can connect both to on-premises Oracle and Oracle Database Cloud — a Database as a Service (DBaaS) solution from Oracle — via secure SSH protocol in the Direct connection mode.
Our product supports public key and password SSH authentication and offers a number of connection string parameters to specify SSH user name and password or a private key and passphrase, acceptable ciphers, SSH host and port.
Note that in order to use SSH, you need to add the “ssh://” prefix to the Host (or Server) connection string parameter and specify the necessary SSH settings.
Here is the complete list of dotConnect for Oracle 9.12.1054 features:
- SSH is supported in the Direct mode
- The "Could not find element type in model" bug when loading XML mapping in .NET Standard LinqConnect assemblies is fixed
- The bug with using enums via .NET Standard compliant assemblies is fixed
- The bug with detecting FK relationships to tables in other schemas by Create Model Wizard and Update From Database Wizard is fixed
- The bug with incorrect SQL generation when using .Substring() in a .Select() statement in EF Core 2 is fixed
- The bug with casting a non-nullable numeric to an Enum during materialization of LINQ query in EF Core is fixed
- The bug with incorrect SQL generation when using .OrderBy() with comparison in EF Core is fixed
http://www.devart.com/dotconnect/oracle/