اتصال به بانکهای اطلاعاتی اوراکل در سی شارپ

       روشهای اتصال به بانکهای اوراکل:

Oracle .NET data provider

OLE DB .NET data provider

ODBC .NET data provider

درمثال زیر به تمام راههای بالا اشاره شده است

using System;

using System.Data.OracleClient;

using System.Data.OleDb;

using System.Data.Odbc;

namespace ConnectOracle

{

class Program Interprocess communication (IPC)

{

static void Main(string[] args)

{

// Connect using .NET data provider for Oracle

string oracleConnectString =

"Data Source=ORCL;User Id=hr;Password=password;";

using (OracleConnection connection =

new OracleConnection(oracleConnectString))

{

connection.Open( );

// Return some information about the server.

Console.WriteLine("---Microsoft .NET Provider for Oracle---");

١٣

Console.WriteLine("ConnectionString = {0}\n", oracleConnectString);

Console.WriteLine("State = {0}", connection.State);

Console.WriteLine("DataSource = {0}", connection.DataSource);

Console.WriteLine("ServerVersion = {0}", connection.ServerVersion);

}

// Connect using .NET data provider for OLE DB.

string oledbConnectString =

"Provider=MSDAORA;Data Source=ORCL;User Id=hr;Password=password;";

using (OleDbConnection connection =

new OleDbConnection(oledbConnectString))

{

connection.Open( );

// Return some information about the server.

Console.WriteLine("\n---Microsoft .NET Provider for OLE DB---");

Console.WriteLine("ConnectionString = {0}\n", oledbConnectString);

Console.WriteLine("State = {0}", connection.State);

Console.WriteLine("DataSource = {0}", connection.DataSource);

Console.WriteLine("ServerVersion = {0}", connection.ServerVersion);

}

// Connect using .NET data provider for ODBC

string odbcConnectString = "Driver={Oracle in OraDb10g_home1};" +

"Server=ORCL;uid=hr;pwd=password;";

using (OdbcConnection connection =

new OdbcConnection(odbcConnectString))

{

connection.Open( );

// Return some information about the server.

١٤

Console.WriteLine("\n---Microsoft .NET Provider for ODBC---");

Console.WriteLine("ConnectionString = {0}\n", odbcConnectString);

Console.WriteLine("State = {0}", connection.State);

Console.WriteLine("DataSource = {0}", connection.DataSource);

Console.WriteLine("ServerVersion = {0}", connection.ServerVersion);

}

Console.WriteLine("\nPress any key to continue.");

Console.ReadKey( );

}

}

}