1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104
|
...
public enum EmDbTypeConnection
{
DBACCESS = 0,
DBORACLE = 1,
DBSQLITE = 2,
DBSQLSERVEUR = 3,
MYSQL = 4
};
...
#region Déclaration des variables
internal DbProviderFactory ProviderFactory { get; set; }
internal System.Data.Common.DbConnection Connection { get; set; }
public EmDbTypeConnection TypeConnection { get; set; }
public string FileName { get; set; }
public string Server { get; set; }
public string DataBase { get; set; }
public string User { get; set; }
public string Password { get; set; }
#endregion
...
public void Open()
{
// Génération de la string de connexion
DbConnectionStringBuilder ConnectionStringBuilder = null;
try
{
switch (TypeConnection)
{
case EmDbTypeConnection.DBACCESS:
{
ProviderFactory = DbProviderFactories.GetFactory("System.Data.OleDb");
ConnectionStringBuilder = ProviderFactory.CreateConnectionStringBuilder();
ConnectionStringBuilder.Add("Provider", "Microsoft.Jet.OLEDB.4.0");
ConnectionStringBuilder.Add("Data Source", FileName);
break;
}
case EmDbTypeConnection.DBSQLSERVEUR:
{
ProviderFactory = DbProviderFactories.GetFactory("System.Data.SqlClient");
ConnectionStringBuilder = ProviderFactory.CreateConnectionStringBuilder();
ConnectionStringBuilder.Add("Data Source", Server);
ConnectionStringBuilder.Add("Initial Catalog", DataBase);
ConnectionStringBuilder.Add("user Id", User);
ConnectionStringBuilder.Add("password", Password);
break;
}
case EmDbTypeConnection.DBSQLITE:
{
ProviderFactory = DbProviderFactories.GetFactory("System.Data.SQLite");
ConnectionStringBuilder = ProviderFactory.CreateConnectionStringBuilder();
ConnectionStringBuilder.Add("Data Source", FileName);
ConnectionStringBuilder.Add("UseUTF16Encoding", false);
break;
}
case EmDbTypeConnection.DBORACLE:
{
//ProviderFactory = DbProviderFactories.GetFactory("System.Data.OracleClient");
ProviderFactory = DbProviderFactories.GetFactory("Oracle.DataAccess.Client");
ConnectionStringBuilder = ProviderFactory.CreateConnectionStringBuilder();
ConnectionStringBuilder.Add("Data Source", Server);
ConnectionStringBuilder.Add("User ID", User);
ConnectionStringBuilder.Add("Password", Password);
//ConnectionStringBuilder.Add("Unicode", true);
break;
}
case EmDbTypeConnection.MYSQL:
{
ProviderFactory = DbProviderFactories.GetFactory("MySql.Data.MySqlClient");
ConnectionStringBuilder = ProviderFactory.CreateConnectionStringBuilder();
ConnectionStringBuilder.Add("Server", Server);
ConnectionStringBuilder.Add("Database", DataBase);
ConnectionStringBuilder.Add("Uid", User);
ConnectionStringBuilder.Add("Pwd", Password);
break;
}
}
if (ConnectionStringBuilder != null)
{
Connection = ProviderFactory.CreateConnection();
Connection.ConnectionString = ConnectionStringBuilder.ConnectionString;
Connection.Open();
}
}
catch (Exception ex)
{
throw ex;
}
} |
Partager