private void connect() { if (sql == null) { sql = FactorySql.Create(sqlprovider); } if (password != string.Empty && !passEstablished) { sqlConnectionString += password; passEstablished = true; } conn = sql.Connection(sqlConnectionString); conn.Open(); }
/// <summary> /// Conecta a la base de datos mediante una única conexión. /// </summary> /// <param name="connStringName">Nombre de la connectionString que está definida en el archivo de configuración de la aplicación.</param> static public void Connect(string connStringName) { if (uniqueconn != null) { string sqlConnString = ConfigurationManager.ConnectionStrings [connStringName].ConnectionString; string sqlProvider = ConfigurationManager.ConnectionStrings [connStringName].ProviderName; ISql consql = FactorySql.Create(sqlProvider); if (password != string.Empty) { sqlConnString += password; } uniqueconn = consql.Connection(sqlConnString); uniqueconn.Open(); } }
private void InitBD() { string connString = ConfigurationManager.ConnectionStrings["GebatDataConnectionString"].ConnectionString; connString += "Password=root"; string provider = ConfigurationManager.ConnectionStrings ["GebatDataConnectionString"].ProviderName; ISql manager = FactorySql.Create(provider); FileInfo file = new FileInfo(scriptfilename); StreamReader lector = file.OpenText(); string script = lector.ReadToEnd(); lector.Close(); DbConnection conn = manager.Connection(connString); conn.Open(); DbCommand comando = manager.Command(script, conn); comando.ExecuteNonQuery(); conn.Close(); }
static public bool AttemptConnection(string connStringName) { try { string trysqlConnectionString = ConfigurationManager.ConnectionStrings[connStringName].ConnectionString; string trysqlprovider = ConfigurationManager.ConnectionStrings [connStringName].ProviderName; ISql tryisql = FactorySql.Create(trysqlprovider); if (password != string.Empty) { trysqlConnectionString += password; } DbConnection tryconn = tryisql.Connection(trysqlConnectionString); tryconn.Open(); tryconn.Close(); return(true); } catch (Exception ex) { return(false); } }