Oracle .NET Data Provider - From Oracle (Oracle.DataAccess.Client)

________________________________________

Oracle .NET Data Provider - From Oracle (Oracle.DataAccess.Client)

____________________________________________________________________

The Oracle Data Provider for .NET (ODP.NET) features optimized data access to the Oracle database from a .NET environment. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security. The data provider can be used from any .NET language, including C# and Visual Basic .NET.

ODP.NET makes using Oracle from .NET more flexible, faster, and more stable. ODP.NET includes many features not available from other .NET drivers, including Multiple Active Result Sets (MARS), a native XML data type, the ability to bind array parameters, and flexible LOB tuning. ODP.NET is designed for scalable enterprise Windows solutions by providing full support for Unicode and local and distributed transactions. Distributed transactions are supported using the Oracle Services for MTS.

Using C#

using Oracle.DataAccess.Client; 

... 

OracleConnection oOracleConn = new OracleConnection(); 

oOracleConn.ConnectionString = 

    "Data Source=MyOracleServerName;" +

    "Integrated Security=SSPI";

oOracleConn.Open();

For more information, see: Oracle Data Provider for .NET.

____________________________________________________________________
Note:If You have need demo then contact with me.Post your request as a comment.
____________________________________________________________________