Skip to content

ericmend/oracleClientCore-2.0

Repository files navigation

News

Nuget Oracle Data Provider for .NET Core Official: https://www.nuget.org/packages/Oracle.ManagedDataAccess.Core

oracleClientCore-2.0

Unofficial Oracle Client for NetCore

Based on projects: Mono and Oracleclientcore from LinqDan

License These files are licensed under the MIT License

*Portuguese Below.

About:

This project is a personal work to 'workaround' the problem with Oracle DataBase and netcoreapp20 (oracle didn't certified ODP.NET Managed Driver in netcoreapp20 yet) odpnet-dotnet-core

Development/Test Environment

  • Install NetCore SDK
  • Install VS Code
  • Install OCI - Oracle Client
    • linux extract the files and setup the environment variable (e.g. LD_LIBRARY_PATH="/opt/oracle/instantclient"; OCI_HOME="/opt/oracle/instantclient"; OCI_LIB_DIR="/opt/oracle/instantclient"; PATH=$PATH:"/opt/oracle/instantclient")
    • windows extract he files and setup enviroment variables. *The database we are using a docker image: sath89/oracle-xe-11g

OBS:.

We did a work to run with windows/linux/macosx. Alread tested with win10 (windows) and ubuntu 17.10 (linux)

See more:

Docker image for ASP.NET Core with Oracle Client

ORM Dapper

PORTUGUESE ---->>>>

Sobre:

Este projeto tem como finalidade disponibilizar uma possibiliade de uso do .NET Core usando banco de dado Oracle (até que a Oracle consiga certificar o ODP.NET, Managed Driver no Microsoft .NET Core) odpnet-dotnet-core

Ambiente de Desenvolvimento/Teste

  • Instalar o SDK do .NET Core
  • Instalar Visual Studio Code
  • Instalar OCI - Client Oracle
    • (linux) Descompactar os arquivos e declarar as variaveis de ambiente. ex: LD_LIBRARY_PATH="/opt/oracle/instantclient"; OCI_HOME="/opt/oracle/instantclient"; OCI_LIB_DIR="/opt/oracle/instantclient"; PATH=$PATH:"/opt/oracle/instantclient"
    • (windows) Descompactar os arquivos e declarar as variaveis de ambiente. ex: LD_LIBRARY_PATH="C:\instantclient_12_2"; OCI_HOME="C:\instantclient_12_2"; OCI_LIB_DIR="C:\instantclient_12_2"; PATH=$PATH:"C:\instantclient_12_2"
  • Banco de Dados pode ser usado o docker: sath89/oracle-xe-11g
  • Disponível em Nuget

Obs:

Foi realizado um trabalho para que trabalhe em Windows/Linux/MacOsX. Testado até o momento apenas Windows (Win10) e Linux (Ubuntu 17.10).

Veja também:

Docker para ASP.NET Core com Oracle Client

ORM Dapper