public IDbConnection Initialize(Connexion connexion, Sgbd sgbd) { switch (sgbd) { case Sgbd.SQLServer: _conn = new SqlConnection(string.Format("Data source ={0}; Initial catalog = {1}; User ID = {2}; Password ={3}", connexion.Server, connexion.Database, connexion.User, connexion.Password)); break; //case ConnexionType.MySQL: // _conn = new MySqlConnection(string.Format("Server={0};Database={1};UserID={2};Password={3}", // connexion.Serveur, connexion.Database, connexion.User, connexion.Password)); // break; //case ConnexionType.PostGrsSQL: // _conn = new NpgsqlConnection(string.Format("Server={0};Database={1};Uid={2};Pwd={3};Port={4}", // connexion.Serveur, connexion.Database, connexion.User, connexion.Password, connexion.Port)); // break; case Sgbd.Oracle: return(null); case Sgbd.Access: _conn = new OleDbConnection(string.Format("Data Source ={ 0 }; Initial catalog ={ 1 }; User ID ={ 2 }; Password ={ 3 }", connexion.Server, connexion.Database, connexion.User, connexion.Password)); break; } return(_conn); }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { switch (comboBox1.SelectedIndex) { case 0: sgbd = Sgbd.SQLServer; break; case 1: sgbd = Sgbd.MySQL; break; case 2: sgbd = Sgbd.PostGrsSQL; break; case 3: sgbd = Sgbd.Oracle; break; case 4: sgbd = Sgbd.Access; break; } }
public Database SetSgbd(Sgbd sgbd) { Sgbd = sgbd; ConnectionString = GetConnectionStringByConfig(); Connection?.Dispose(); return(this); }
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e) { switch (comboBox1.SelectedIndex) { case 0: sgbd = Sgbd.SQLServer; break; } }
public Database(Sgbd sgbd, string connectionString) { Sgbd = sgbd; ConnectionString = connectionString; Parameters = new List <DatabaseParameter>(); CloseConnectionAfterExecuted = true; OpenConnectionBeforeExecuted = true; UseTransaction = false; AutoCommit = true; UseDataReaderToGetData = true; }
public DataBase(Sgbd.Type type, string connexionstring) { try { switch (type) { case Sgbd.Type.POSTGRES: sgbd = new Postgres(connexionstring); break; case Sgbd.Type.MYSQL: sgbd = new Mysql(connexionstring); break; } foreach (PropertyInfo dbset in GetType().GetProperties()) { Type[] arguments = dbset.PropertyType.GetGenericArguments(); if (arguments.Length > 0) { Type table = arguments[0]; string query = sgbd.CreateTable(table); Console.WriteLine(query); using (DbConnection dbcon = sgbd.GetConnection()) { if (dbcon != null) { DbCommand command = sgbd.GetCommand(query, dbcon); try { command.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } } } dbset.SetValue(this, Activator.CreateInstance(dbset.PropertyType)); } } catch (Exception ex) { Console.WriteLine(ex.Message); } instance = this; }
public LogImportacaoRepository(Sgbd sgbd, string connectionString) : base(sgbd, connectionString) { }
public LogImportacaoRepository(Sgbd sgbd) : base(sgbd) { }