VistaDB (VistaDB.Provider)

____________________________________________________________________

VistaDB (VistaDB.Provider)

____________________________________________________________________

The VistaDB Provider allows you to access a VistaDB database.

Using C#

using VistaDB.Provider; 

... 

public VistaDBConnection OpenConnection()

{

    string connectionString = @"Data Source = C:\VistaDB.vdb3; Open Mode = ExclusiveReadWrite";

    VistaDBConnection connection = new VistaDBConnection(connectionString);

    connection.Open();

    return connection;

} 

Reffer: http://www.carlprothman.net/Default.aspx?tabid=86

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

Sybase Adaptive Server (ASE) Enterprise .NET Data Provider (Sybase.Data.AseClient)

________________________________________________________

Sybase Adaptive Server (ASE) Enterprise .NET Data Provider (Sybase.Data.AseClient)

____________________________________________________________________

The ASE Enterprise .NET Data Provider is an add-on component to the .NET Framework that allows you to access a Sybase Adaptive Server Enterprise (ASE) database.

Using C#

using Sybase.Data.AseClient; 

... 

AseConnection oAseConn = new AseConnection(); 

oAseConn.ConnectionString = 

    "Data Source=(local);" + 

    "Initial Catalog=myDatabaseName;" + 

    "User ID=myUsername;" + 

    "Password=myPassword" 

oAseConn.Open(); 

For more information, see: ASE
User's Guide

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

PostgreSQLDirect .NET Data Provider - From CoreLab (CoreLab.PostgreSql)

_________________________________________________________

PostgreSQLDirect .NET Data Provider - From CoreLab (CoreLab.PostgreSql)

____________________________________________________________________

PostgreSQLDirect .NET is data provider to direct access to PostgreSQL database for the Microsoft .NET Framework and .NET Compact Framework. It completely based on ActiveX Data Objects for the .NET Framework (ADO.NET) technology. ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational data, XML, and application data.

PostgreSQLDirect .NET data provider can be used in the same way as the SQL Server .NET or the OLE DB .NET Data Provider.

Using C#

using CoreLab.PostgreSql; 

... 

PgSqlConnection oPgSqlConn = new PgSqlConnection();

oPgSqlConn.ConnectionString = 

    "User ID=myUsername;" + 

    "Password=myPassword;" + 

    "Host=localhost;" + 

    "Port=5432;" + 

    "Database=myDatabaseName;" + 

    "Pooling=true;" + 

    "Min Pool Size=0;" + 

    "Max Pool Size=100;" + 

    "Connection Lifetime=0"; 

oPgSqlConn.Open();

For more information, see: PostgreSQLDirect .NET Data Provider. Download here. Support forms here.

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

OraDirect .NET Data Provider - From CoreLab (CoreLab.Oracle)

_________________________________________________________

OraDirect .NET Data Provider - From CoreLab (CoreLab.Oracle)

____________________________________________________________________

OraDirect .NET is a data provider to direct access to Oracle database server for the Microsoft .NET Framework and .NET Compact Framework. It is completely based on ActiveX Data Objects for the .NET Framework (ADO.NET) technology. ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational data, XML, and application data.

OraDirect .NET data provider can be used in the same way as the SQL Server .NET or the OLE DB .NET Data Provider. OraDirect .NET can access Oracle server using Oracle Call Interface (OCI) or through TCP/IP directly.

Using C#

using CoreLab.Oracle; 

... 

OracleConnection oOracleConn = new OracleConnection(); 

oOracleConn.ConnectionString = 

    "User ID=myUsername;" + 

    "Password=myPassword;" + 

    "Host=(local);" + 

    "Pooling=true;" + 

    "Min Pool Size=0;" + 

    "Max Pool Size=100;" + 

    "Connection Lifetime=0"; 

oOracleConn.Open();

For more information, see: OraDirect .NET Data Provider. Download here.
Support forms here

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

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.
____________________________________________________________________

Oracle .NET Data Provider - From Microsoft (System.Data.OracleClient)

________________________________________

Oracle .NET Data Provider - From Microsoft (System.Data.OracleClient)

____________________________________________________________________

The Microsoft .NET Framework Data Provider for Oracle is an add-on component to the .NET Framework 1.0 that provides access to an Oracle database using the Oracle Call Interface (OCI) as provided by Oracle Client software. Oracle 8i Release 3 (8.1.7) Client or later must be installed for this provider to function correctly.

Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.

Using C#:

using System.Data.OracleClient; 

... 

OracleConnection oOracleConn = new OracleConnection(); 

oOracleConn.ConnectionString = 

     "Data Source=Oracle8i;" + 

     "Integrated Security=SSPI"; 

oOracleConn.Open();

For more information, see: OracleConnection Class and .NET Data Providers.

To view Microsoft KB articles related to OracleConnection, click here
____________________________________________________________________
Note:If You have need demo then contact with me.Post your request as a comment.
____________________________________________________________________

MySQLDirect .NET Data Provider - From CoreLab (CoreLab.MySql)

____________________________________________________________________

MySQLDirect .NET Data Provider - From CoreLab (CoreLab.MySql)

____________________________________________________________________

MySQLDirect .NET is data provider to direct access to MySQL database server for the Microsoft .NET Framework and .NET Compact Framework. It is completely based on ActiveX Data Objects for the .NET Framework (ADO.NET) technology. ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational data, XML, and application data.

MySQLDirect .NET data provider can be used in the same way as the SQL Server .NET or the OLE DB .NET Data Provider. Data provider can access MySQL server either using native MySQL network protocol directly or through MySQL client library. It allows to create lightweight and fast applications working with MySQL.

Using C#

uusing CoreLab.MySql; 

... 

MySqlConnection oMySqlConn = new MySqlConnection(); 

oMySqlConn.ConnectionString = 

    "User ID=myUsername;" + 

    "Password=myPassword;" + 

    "Host=localhost;" + 

    "Port=3306;" + 

    "Database=myDatabaseName;" + 

    "Direct=true;" + 

    "Protocol=TCP;" + 

    "Compress=false;" + 

    "Pooling=true;" + 

    "Min Pool Size=0;" + 

    "Max Pool Size=100;" + 

    "Connection Lifetime=0"; 

oMySqlConn.Open();

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

Microsoft SQL Server .NET Data Provider (System.Data.SqlClient)

________________________________________

Microsoft SQL Server .NET Data Provider (System.Data.SqlClient)

____________________________________________________________________

The Microsoft SQL Server .NET Data Provide allows you to connect to a Microsoft SQL Server 7.0, 2000, and 2005 databases.

For Microsoft SQL Server 6.5 or earlier, use the OLE DB .NET Data Provider with the SQL Server OLE DB Provider (SQLOLEDB).

Using C#:

using System.Data.SqlClient; 

... 

SqlConnection oSQLConn = new SqlConnection(); 

oSQLConn.ConnectionString = 

    "Data Source=(local);" + 

    "Initial Catalog=myDatabaseName;" +

    "Integrated Security=SSPI";

 //Or

 // "Server=(local);" + 

 // "Database=myDatabaseName;" + 

 // "Trusted_Connection=Yes";

oSQLConn.Open(); 

... 

oSQLConn.Close();

// If you open the connection, then close the connection!

// Otherwise the connection does not go back into the connection pool.

// Note the SqlDataAdapter will open and close the connection for you

// when calling it's Fill or Update methods. However if the connection

// is already open, the SqlDataAdapter will leave it open.

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

Database in Dotnet

Now learn How to connect database with dotnet.
Best of luck