C# (CSharp) Iconnection Examples

Programming Language: C# (CSharp)

Class/Type: Iconnection

Examples at hotexamples.com: 8

IConnection is an interface implemented in C# that represents a connection to a database. It defines methods for opening, closing, and checking the state of the connection.

Example 1: SqlConnection

The following code creates a SqlConnection object, opens the connection using the Open() method, executes a query, and closes the connection using the Close() method.

using System.Data.SqlClient;

string connectionString = "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    // Execute query
    connection.Close();
}

This example uses the System.Data.SqlClient package library.

Example 2: MySqlConnection

The following code creates a MySqlConnection object, opens the connection using the Open() method, executes a query, and closes the connection using the Close() method.

using MySql.Data.MySqlClient;

string connectionString = "Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;";
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
    connection.Open();
    // Execute query
    connection.Close();
}

This example uses the MySql.Data package library.

C# (CSharp) Iconnection - 8 examples found. These are the top rated real world C# (CSharp) examples of Iconnection extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

Get(5)

Conexao(2)

Example #1

Show file

File: 777906-19000188-47982856-2.cs Project: shendongnian/download4

 public WCF(Iconnection con)
 {
     if (con != null)
     {
         connectionHandler = con;
     }
     else
     {
         connectionHandler = takedefault;
     }
 }

Example #2

Show file

 public DaoCidade(Iconnection Conexion)
 {
     this._conexion = Conexion;
 }

Example #3

Show file

File: ProdutosDAO.cs Project: paulosergiodebastiani/ExemploEmSala

 public ProdutosDAO()
 {
     conexao = new Connection();
 }

Example #4

Show file

 public DaoMaeAluno(Iconnection Conexion)
 {
     this._conexion = Conexion;
 }

Example #5

Show file

File: DaoEnderecoAluno.cs Project: deftnesssolutions/Escola.Web

 public DaoEnderecoAluno(Iconnection Conexion)
 {
     this._conexion = Conexion;
 }

Example #6

Show file

File: DaoBairro.cs Project: deftnesssolutions/Escola.Web

 public DaoBairro(Iconnection Conexion)
 {
     this._conexion = Conexion;
 }

Example #7

Show file

File: DaoEstado.cs Project: deftnesssolutions/Escola.Web

 public DaoEstado(Iconnection Conexion)
 {
     this._conexion = Conexion;
 }

Example #8

Show file

File: DaoUsuario.cs Project: deftnesssolutions/Escola.Web

 public DaoUsuario(Iconnection Conexion)
 {
     this._conexion = Conexion;
 }