Connecting to Oracle Database through C#?

by

First off you need to download and install ODP from this site
http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

After installation add a reference of the assembly Oracle.DataAccess.dll.

Your are good to go after this.

using System; 
using Oracle.DataAccess.Client; 

class OraTest
{ 
    OracleConnection con; 
    void Connect() 
    { 
        con = new OracleConnection(); 
        con.ConnectionString = "User Id=<username>;Password=<password>;Data Source=<datasource>"; 
        con.Open(); 
        Console.WriteLine("Connected to Oracle" + con.ServerVersion); 
    }

    void Close() 
    {
        con.Close(); 
        con.Dispose(); 
    } 

    static void Main() 
    { 
        OraTest ot= new OraTest(); 
        ot.Connect(); 
        ot.Close(); 
    } 
}

More Related Contents:

  1. Merge two arrays and return sorted array in c# [closed]
  2. Annual calender in asp.net page [closed]
  3. auto click in C# in difrent position of screen [closed]
  4. How to String Format [closed]
  5. Covariance and contravariance real world example
  6. How to execute an .SQL script file using c#
  7. Interop type cannot be embedded
  8. C# Create New T()
  9. out of memory Image.FromFile
  10. Dynamically adding properties to an ExpandoObject
  11. No Main() in WPF?
  12. Why are C# 4 optional parameters defined on interface not enforced on implementing class?
  13. Calling Oracle stored procedure from C#?
  14. When should one use dynamic keyword in c# 4.0?
  15. _=> what does this underscore mean in Lambda expressions?
  16. Check if list contains any of another list
  17. ThreadPool.QueueUserWorkItem vs Task.Factory.StartNew
  18. Why is AddRange faster than using a foreach loop?
  19. Why am I getting ‘One or more types required to compile a dynamic expression cannot be found.’?
  20. C# parameterized queries for Oracle – serious & dangerous bug!
  21. How to implement batch fetching with Fluent NHibernate when working with Oracle?
  22. Serialize an object to XElement and Deserialize it in memory
  23. Get chrome browser title using c#
  24. Question about C# covariance
  25. Oracle Parameters with IN statement?
  26. How to return oracle output parameters from a stored procedure in .NET
  27. Insert blob in oracle database with C#
  28. Get values between curly braces c#
  29. ODP.NET Managed library does resolve alias, but 32-bit library does
  30. Visual Studio 2010: How to enforce build order of projects in a solution?

Leave a Comment