public static bool TestConnection(ConnectionInfo conInfo, out Exception exception) { bool succ = false; IConnectionFactory fac = null; if (conInfo.Type == ConnectionType.SqlServer) { fac = new SqlServerConnectionFactory(); } else if (conInfo.Type == ConnectionType.MySql) { fac = new MySqlConnectionFactory(); } using (IDbConnection con = fac.CreateConnection(conInfo)) { try { con.Open(); exception = null; succ = true; } catch (Exception ex) { exception = ex; succ = false; } } return succ; }
public string CreateConnectionString(ConnectionInfo conInfo) { StringBuilder sb = new StringBuilder(); if (!string.IsNullOrEmpty(conInfo.Server)) { sb.AppendFormat("Data Source={0};", conInfo.Server); } if (!string.IsNullOrEmpty(conInfo.Catalog)) { sb.AppendFormat("initial catalog={0};", conInfo.Catalog); } if (!string.IsNullOrEmpty(conInfo.User)) { sb.AppendFormat("User={0};", conInfo.User); } if (!string.IsNullOrEmpty(conInfo.Password)) { sb.AppendFormat("Password={0};", conInfo.Password); } if (string.IsNullOrEmpty(conInfo.User) && (string.IsNullOrEmpty(conInfo.Password))) { sb.Append("Integrated Security=True;"); } string cs = sb.ToString(); return cs; }
public static Schema CreateFromConnection(ConnectionInfo conInfo) { Schema schema = new Schema(); schema.CatalogName = conInfo.Catalog; schema.Name = conInfo.Schema; IConnectionFactory fac = null; ISqlConf sqlConf = null; if (conInfo.Type == ConnectionType.SqlServer) { fac = new SqlServerConnectionFactory(); sqlConf = new SQLServerDefaultConf(); schema.Platform = "SQLSERVER"; } else if (conInfo.Type == ConnectionType.MySql) { fac = new MySqlConnectionFactory(); sqlConf = new MySqlDefaultConf(); schema.Platform = "MYSQL"; } using (IDbConnection conn = fac.CreateConnection(conInfo)) { conn.Open(); IDatabaseExplorer dbExplorer = new DatabaseExplorer(conn, sqlConf); schema.Tables = dbExplorer.GetTables(schema).ToList<Table>(); schema.StoredProcedures = dbExplorer.GetStoredProcedures(schema).ToList<StoredProcedure>(); } return schema; }
private ConnectionInfo getConInfo() { ConnectionInfo ci = new ConnectionInfo(); ci.User = cmbAuth.SelectedIndex == 1 ? cmbUser.Text : null; ci.Password = cmbAuth.SelectedIndex == 1 ? edtPassword.Text : null; ci.Server = cmbServer.Text; ci.Catalog = cmbDatabase.Text; ci.Schema = edtSchema.Text; return ci; }
public IDbConnection CreateConnection(ConnectionInfo conInfo) { IDbConnection conn = null; try { string cs = CreateConnectionString(conInfo); conn = new MySqlConnection(cs); } catch { // log exception } return conn; }
public IDbConnection CreateConnection(ConnectionInfo conInfo) { string cs = CreateConnectionString(conInfo); SqlConnection conn = new SqlConnection(cs); return conn; }
private void btnOK_Click(object sender, EventArgs e) { Exception err = null; bool succ = ConnectionTester.TestConnection(getConInfo(), out err); if (!succ) { MessageBox.Show(err.Message, "Failure", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } this.connectionInfo = getConInfo(); this.DialogResult = DialogResult.OK; this.Close(); }
public string CreateConnectionString(ConnectionInfo conInfo) { string cs = string.Format("server={0}; user id={1}; password={2}; database={3}", conInfo.Server, conInfo.User, conInfo.Password, conInfo.Catalog); return cs; }