Oracle provider

[jpiquot]

Hi Sebastien,

As we need an Oracle provider for YesSql (to be used with OrchardCore). We can write the Oracle provider so you can add it to the YesSql project, if you agree.

[hishamco]

Is there an Oracle implementation that support .NET Core?

[jpiquot]

Hi,
No, nothing official from oracle yet. You have to target net461 or use the .Net Core Provider for Oracle from DevArt

[hishamco]

Sometimes net461 isn't the right option for all the projects, and regarding DevArt Oracle provider i'm not sure if it's free & open source or not

[jpiquot]

I don't understand why Oracle does not support .Net Core. They did not even take the time to update the roadmap since march 2017.

[alexbocharov]

Need an official provider from Oracle (free & open source)

[jpiquot]

Is there an issue to build YesSql with target net461? EF Core team are working on Oracle EF Core support but only target .NET until the .NET Core driver will be available. Can we do the same?

[alexbocharov]

Yes, using Oracle.Data.Access (free). But is it worth it...
Who considers it necessary?

[alexbocharov]

I was waiting for the official support of .NET Core from Oracle

[beppler]

Hi.

Oracle launched the .NET Core provider.

It can be downloaded on nuget.

[sebastienros]

Is there a docker image running on Windows that can be used to test it? I would not commit to it if there is no way to test it works.

[beppler]

Oracle has an registry with standard and enterprise editions that can be used for testing environments.

Enterprise edition is available on docker store.

[mguzzardi]

Hi,

I started an Oracle Provider (v12c only)
https://github.com/mguzzardi/yessql

I got 82 tests Passed and 21 Failed.

I'm struggling with "IN" Operator and boolean datatype. I need to look how dapper work with Oracle.

For information, a non exhaustive list of differences for Oracle:

• empty string is equivalent to NULL : empty string is replaced by "null"
• parameters/bind variables : must be prefixed by ":" instead of "@"
• DBCommand must be configured to BindByName=true (quick and dirty fix in my code)
• end of sql statement : semicolon not allowed
• "returning into" : I needed to write PL/SQL code to do that
• Oracle Database does not support the creation of indexes for primary keys, since an index is implicitly created for all primary keys (same for unique key) : not fixed

[pbros]

Hello,

I'd be interested in using Oracle with YesSQL (through OrchardCore). Has any progress been made?

Thanks

[jpiquot]

Hi @pbros,

Using Oracle with .NET Core is a real risk today as Oracle does not invest much on .NET Core. As an example, see the EF Core driver that has not been released. If you want to use Oracle, it may be better to consider Java.

YesSQL, like many libraries in the .NET world that need persistence, support many databases, but not Oracle. Or if they support it, say that it's not tested or like Dapper tested but with many bugs remaining.