본문 바로가기

DevOps/Visual Studio

Visual Studio Oracle 설치 방법

728x90
반응형
SMALL

Windows 환경 설정

 

https://www.oracle.com/technetwork/database/windows/downloads/index-101290.html

  • Oracle Developer Tools for Visual Studio 2017 -MSI Installer
  • Oralce Data Access Compaonents (ODAC) with Oracle Developer Tools for Visual Stuio
  • 파일 다운로드 설치
  1. ODAC 설치

Lab(접속별칭) =

   (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.62.120)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = XE(서비스이름))

    )

  )

 

 

 

-> sqlnet.ora

#SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

 

Visual Studio 환경 설정

 

https://csharp.today/entity-framework-6-database-first-with-oracle/

 

-> Model 생성시 관리되는 드라이버로 생성

 

 

 

 

 

 

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/dotnet/NuGet/index.html

728x90
반응형
LIST