Exemple #1
0
        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;
        }
Exemple #3
0
        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;
        }
Exemple #4
0
 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;
 }
Exemple #7
0
 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;
 }